Query result displays NON selected fields

[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.

 

[Golfinray]

Go into the area where you drop tables, right click to get properties, and
set output all fields to no.

 

[John W. Vinson]

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.

Open the query in SQL view. If there are any asterisks in the SELECT clause,
remove them.

 

[Fresh_acorn]

Thanks! That did the trick!

Go into the area where you drop tables, right click to get properties, and
set output all fields to no.