best training access course - Queries and Labels

Resolved · Low Priority · Version Standard

Queries and Labels

Lizzie has attended:
Access Introduction course

by - delegate Lizzie [2 posts] (2007 Oct 18 Thu, 10:17) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Queries and Labels

by - trainer David gold contributer [428 posts] (2007 Oct 19 Fri, 12:30) Reply

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

by - delegate Jon [3 posts] (2007 Oct 22 Mon, 21:37) Reply

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

by - delegate Lizzie [2 posts] (2007 Oct 23 Tue, 09:37) Reply

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

· MS Access and Database Normalisation
· Microsoft Access Courses
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Microsoft Access: Unleash the True Potential Today
· Why consider Access Visual Basic training?

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Rate this page: