best training access course - queries and labels
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 18 Oct 2007, 10:17Delegate Lizzie said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Fri 19 Oct 2007, 12:30Trainer David said...

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

replyReply Mon 22 Oct 2007, 21:37Delegate Jon said...

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

replyReply Tue 23 Oct 2007, 09:37Delegate Lizzie said...

RE: Queries and Labels

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

 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard