I have a query Im working on. It has several fields three of which are cat1 cat 2 and quantity.
In cat1 and cat 2 I want to delete seven, three digit codes from the query while quantity remains >0. I also want to display all null values in cat1 and 2. SO my theory was to type:
Not "333" And "334" And "335" etc till all 7 codes for both cat 1 and 2 and place the criteria for quantity as >0. Next row down for criteria I would put Is Null in cat 1 and 2 and >0 for qty. However when I do this it never works. It usually ends up deleting unecassary codes or not deleting any codes. All I can seem to do is delete one code instead of the desired multiple. So If I do -Not "333"- for just cat1 using no other codes or fields then it works. But, I cannot seem to get rid of any other codes in the query by specifying the criteria.
Ex of not working criteria set forth:
field: Cat1 | Cat2 | quantity
criteria: Not "333" And "334" And...(till all 7 are entered)| Not "333" And "334" And...(till all 7 are entered)| >0
I must say Im at a bit of a loss and would greatly appreicate any and all help! Thanks!