troubleshooting Question

Access - Expand * field selection in query

Avatar of RichNH
RichNH asked on
Microsoft Access
11 Comments2 Solutions572 ViewsLast Modified:
Hello,  I am using MS Access 2007.  I am curious if there is some way I can do the following.

I want to create a query in the following manner.  Open a new query, select all fields by double clicking the asterisk in the table's list of fields.  Now here's the part I am curious about.

After I have selected the asterisk to get all fields  I want Access to expand that asterisk to list each individual field.  The end result would be the same as if I went down the list of fields in the table and selected each individual field instead of selecting the asterisk.

Why?  I have tables with A LOT of fields in them, almost all of which I want selected.  The key word here is "almost" which as we all know only counts in hand grenades, horseshoes and tactical nuclear weapons.  I'm looking for a  short cut way to avoid having to double click "almost" each and every field in the table.  If I can get Access to select all the table's fields automatically, I can then just scroll over and delete the few fields I don't want.
Join our community to see this answer!
Unlock 2 Answers and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros