Queries Returning Too Many Fields

  • Thread starter Thread starter NChris
  • Start date Start date
N

NChris

The Problem: When I start a new query, select one table,
select one field to be returned, and then run it all of
the fields are returned in the query results.

This is only happening on one machine in the office and it
does not matter what database is opened, the same thing
occurs. This makes me think that the issue lies at the
Access level on that specific computer and not at the
database level since other machines are not experiencing
the same problem with the same databases when creating the
same queries.

Does anyone know what is going on?

Thanks,
N
 
Hi,


There is an option to return all the fields from queries, it is probably
checked. ( Tools | Options... [ Table/Query ] )



Hoping it may help,
Vanderghast, Access MVP
 
Thanks, that worked!
-----Original Message-----
Hi,


There is an option to return all the fields from queries, it is probably
checked. ( Tools | Options... [ Table/Query ] )



Hoping it may help,
Vanderghast, Access MVP


The Problem: When I start a new query, select one table,
select one field to be returned, and then run it all of
the fields are returned in the query results.

This is only happening on one machine in the office and it
does not matter what database is opened, the same thing
occurs. This makes me think that the issue lies at the
Access level on that specific computer and not at the
database level since other machines are not experiencing
the same problem with the same databases when creating the
same queries.

Does anyone know what is going on?

Thanks,
N
Click to expand...


.
Click to expand...
 
Back
Top