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.
 
Back
Top