Confused about AND and OR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a field called "DeleteFlag". If this field is true, the
record is marked as deleted. I want to create a query which will check for
nulls in other fields. I am having trouble with this. Basically, I want to
have a query that looks for nulls in certain fields in a record, where the
record's "DeleteFlag" is = NO.

So.. filter out any records that have been marked as deleted. With the
records that are left, filter for any fields that are null.

Do I have to use a subquery for this? Or am I using the design grid
incorrectly?

Thanks!
 
you would place your criteria on separate lines in the query design grid.
This creates and "OR" condition. Under your "DeletFlag" put =True and then
put IS Null under your other fields. Each entry on a separate line.

Hope that helps,
 
Back
Top