show all fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just recently started working on a new db. When running queries all fields
are displaying instead of just those that I selected in the design of the
query. I haven't seen this before. Is there something I can turn off so
that this "show all fields" does not continue to default to yes?

TIA
 
Click on Tools, Options, the Tables/Queries tab. Uncheck the Show All
Fields checkbox.

Good luck

Jeff Boyce
<Access MVP>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Max Date in a query whilst showing all fields 4
Query result shows all fields 1
Query shows all fields... 3
Split data in field on character return 0
Tallying Null fields 6
QBE 3
Make table query: [Enter 1] AS Test 1

Back
Top