Query shows all fields...

[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

 

[KARL DEWEY]

Open the query in design view and then switch to SQL View.
See if the SELECT includes an asterisk - if so, then delete it.

 

[Jerry Whittle]

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.

 

[Dustin]

Thanks. "Output All Fields" was set to Yes. Thanks for your help.