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