Report Query

  • Thread starter Thread starter Steve
  • Start date Start date
S

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!
 
Steve said:
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!
Click to expand...


Patience.

Check the replies to your earlier post with the same
question.
 
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).
 
Back
Top