Why Query isn't filtering the selected fields?

S

shelley kline

Hello,
Can anyone help me to figure out why my queries are not
showing the selected fields when run? The query is running
as built, but it is also showing the rest of the entire
table's fields NOT SELECTED in the query- ?

When I go back into the design view the rest of the
table's fields are not showing in the query - only when I
run it... why is this happening?
 
A

Allen Browne

In query design view, open the Properties box (View menu).
Set the "Output all fields" property to No.

If that does not solve the problem, switch the query to SQL view (View
menu), copy what you see and paste it into this thread.
 
S

Shelley Kline

I don't have "Output All Fields" property in my properties
box... only these:
Description
Format
Input mask
Caption

and then a tab to 'Look up" ...
 
A

Allen Browne

You are looking at the properties of a field.
Examine the properties of the query, i.e. click in the blank space beside
the tables in the upper pane.
 
Top