Exclude Items in a Query

[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

 

[John Vinson]

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

For the Backordered, just set a criterion of

=0 OR IS NULL

For Obsolete, use a criterion of

<> "Y"

(not equal to Y)