Can i Filter particular values from a Query????

[JustMaybe]

Hi, I have used queries before, but never filters.
I have a query to display all products bought in the sub form (order Details ) of my orders form.
However there are two products out of hundreds that I do not want to display.
Can I use a filter to block these values from appearing in my query…and if so …where would I begin???
Thanks in advance for any help or recommendations!!!!

S

 

[GHolden]

If you never want them to show in the query..

Assuming you have a unique code for the product and for example the unique codes for the products you don't want to see were 3 and 5. In the criteria under the unique code in the query put

<>3 And <>5

There are two ways to write error-free programs; only the third one works.

 

[PaulBricker]

S,
Open the query in Design View. Look for the Criteria line in the Column of the field with the values you want to filter. On that line, put
<>&quot;Item1&quot; And <>&quot;Item2&quot;

where Item1 and Item2 are the items you don't want to see in the query.

Paul