Querying IsNull in multiple fields

[ChrisCione]

I'm trying to create an "IsNull" query that will return results if no value was found in EITHER one of two fields.

For example:

Field 1 = Create Ad
Field 2 = Distribute Ad

I would like to be able to search multiple records and return all records containing no value in EITHER field 1 or 2 (or both). In other words, if a record contains no value in ANY of those fields, I would like to see this in the query.

Can this be done in one query?

 

[KenHigg]

Can't you simply put IsNull in the query builder in the criteria row for these two fields?

 

[ChrisCione]

I did, but it's only returning records which have no value in BOTH fields. I would like an either/or situation.

 

[KenHigg]

Put them on seperate lines in the criteria rows and it will make it and 'or' type criteria...

 

[ChrisCione]

Thanks. So simple, but I would have never gotten it.

 

[KenHigg]

Been there - Glad to help