Query shows all fields...

  • Thread starter Thread starter Dustin
  • Start date Start date
D

Dustin

I am trying to pull just two fields from a table that has a large number of
fields. Using the design view, I pull the two fields into the grid and run
the query. However, when I do, the query shows every field from the table in
the query.

I've run these queries 1,000 times, but this just started. Does anybody
know of a setting that needs to be changed. I am at a loss.

Thanks,
Dustin
 
Open the query in design view and then switch to SQL View.
See if the SELECT includes an asterisk - if so, then delete it.
 
When in query design view, right click up near the tables and bring up
Properties. Make sure that Output All Fields is set to No.

If that doesn't work, go to SQL View and make sure that there isn't a *
somewhere after the SELECT clause.

If that doesn't work, go to Tools, Options, Tables/Queries tab and make sure
that Output All Fields isn't checked.
 
Back
Top