Query shows all the records of the tables without even selection

  • Thread starter Thread starter Mishanya
  • Start date Start date
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?
 
Right click in the area where you put your tables, choose disply and fields,
and change to no.
 
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?
 
For ACCESS 2003 and earlier:

Tools | Options | Tables/Queries

Uncheck the box "Output all fields"
 
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

DELETE FROM a table WHERE... 1
Blank shows in combo when there is an excluded record 2
Access Query - "Duplicate Records Selected" 5
Append Query Problem 20
Unlinked Tables affecting Query? 5
Using 2 criteria for the same field 4
Access stripping decimal places in query 1
Query does not show all 1

Back
Top