Exclude Items in a Query

  • Thread starter Thread starter Dick Bell
  • Start date Start date
D

Dick Bell

I have an inventory field "Backordered"; if the field value is >0 or an item
is on backorder I want to exclude that item from my query. Also a similiar
field, "Obselete", always has either a Y or N. How do I exclude an item
where the field contains a Y?
Thanks for your help,
Dick
 
I have an inventory field "Backordered"; if the field value is >0 or an item
is on backorder I want to exclude that item from my query. Also a similiar
field, "Obselete", always has either a Y or N. How do I exclude an item
where the field contains a Y?
Thanks for your help,
Dick
Click to expand...

For the Backordered, just set a criterion of

=0 OR IS NULL

For Obsolete, use a criterion of

<> "Y"

(not equal to Y)
 
Back
Top