best training access course - queries and labels

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » best training access course - Queries and Labels

best training access course - Queries and Labels

resolvedResolved · Low Priority · Version Standard

Lizzie has attended:
Access Introduction course

Queries and Labels

Can you include a label as a field in a query if you have one on a form?

RE: Queries and Labels

Hi Lizzie

Unfortunately no, you cannot include a label as part of a query. You can however include any field that you have created for any table.

If you have any further questions please post back.

Hope this helps
David

RE: Queries and Labels

Hi Lizzie,

If you right click on the query field in design view then you can give it a 'Caption' in the list of options.

Cheers

RE: Queries and Labels

Thanks Jon. I'll give it a go...


 

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips


Server loaded in 0.09 secs.