Query shows all the records of the tables without even selection

M

Mishanya

Whenever I create a new query with Design View and add table/s, the output
shows all the fields of all the table/s, even though no fields are selected
into the grid.
The SQL statment is

SELECT *
FROM tblName;

S I have to choose the wanted fields and then to delete " *, " from the end
of the SQL statment in order to get only the needed selection.

Is it some cind of corruption?
 
G

golfinray

Right click in the area where you put your tables, choose disply and fields,
and change to no.
 
M

Mishanya

OK, Got it, thanks.
I can't recall doing anything to change this option to YES. Is there anyway
to make this option NO permanently?
 
K

Ken Snell \(MVP\)

For ACCESS 2003 and earlier:

Tools | Options | Tables/Queries

Uncheck the box "Output all fields"
 
M

Mishanya

golfinray and Ken.
Thank U very much!

Ken Snell (MVP) said:
For ACCESS 2003 and earlier:

Tools | Options | Tables/Queries

Uncheck the box "Output all fields"
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Have both records from two queries/tables under one Query without related fields. 0
Query shows all fields... 3
Query does not show all 1
Retrieve all records in query (even blank) 3
Access Query - "Duplicate Records Selected" 5
Using 2 criteria for the same field 4
How do you make a Query that shows records even if a field is blan 5
Append Query Problem 20

Top