Query result displays NON selected fields

  • Thread starter Thread starter Fresh_acorn
  • Start date Start date
F

Fresh_acorn

In Access 2007, I have a multi-table query with a few selected fields from
each table. Trouble is, the answer table shows every field from every table.
How can I get a result with ONLY the fields I've check marked in the query?
In the Access "options" menu I've deselected the "show all fields" box.
 
Go into the area where you drop tables, right click to get properties, and
set output all fields to no.
 
In Access 2007, I have a multi-table query with a few selected fields from
each table. Trouble is, the answer table shows every field from every table.
How can I get a result with ONLY the fields I've check marked in the query?
In the Access "options" menu I've deselected the "show all fields" box.
Click to expand...

Open the query in SQL view. If there are any asterisks in the SELECT clause,
remove them.
 
Thanks! That did the trick!

Golfinray said:
Go into the area where you drop tables, right click to get properties, and
set output all fields to no.
Click to expand...
 
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

Query Returning Multiple Results 1
Make table query: [Enter 1] AS Test 1
#error - Blank 3
Memo fields not displaying in query 4
Split data in field on character return 0
Dcount returning no results!!! 0
dynamic calculated field in query 3
Access 2007: Need more info on 'concatenante fields' 1

Back
Top