98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access Query fields
Access Query fields
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Display current date & time in column of any widthThe 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 ### |