Report Query

[Steve]

If I have 7 categories in my query, and I want to run a query that if ANY of
the 7 fields are blank, how do I do that? I know that "Is Null" field is a
way if I was just checking one of the categories, but I want to check all 7
categories, and if ANY of them are blank, then display it.. Please help!

 

[Marshall Barton]

If I have 7 categories in my query, and I want to run a query that if ANY of
the 7 fields are blank, how do I do that? I know that "Is Null" field is a
way if I was just checking one of the categories, but I want to check all 7
categories, and if ANY of them are blank, then display it.. Please help!

Patience.

Check the replies to your earlier post with the same
question.

 

[Pendragon]

In design view of your query, in the criteria section, you will put Is Null
once for each field, and each Is Null will be on a separate line (the OR
function or the criteria section).