access query fields

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Query fields

Access Query fields

resolvedResolved · Medium Priority · Version 2010

Wai has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel Pivot Tables course
Excel PowerPivot course
Excel Advanced - Formulas & Functions course
Visio Introduction course
Visio Advanced course

Access Query fields

How do I select ALL fields from table to query (rather than one by one)?

RE: Access Query fields

Hello Wai,

To select all fields, click the first one then hold the shift key down while you click the last one required. Access selects all the fields between.

If you want to select multiple fields that are not all together, click 1st, then hold the Control key down as you randomly click the other fields required!


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 1 Dec 2011: Automatically marked as resolved.


 

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips


Server loaded in 0.06 secs.