Why Query isn't filtering the selected fields?

  • Thread starter Thread starter shelley kline
  • Start date Start date
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?
 
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.
 
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" ...
 
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.
 
Back
Top