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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report query / filters 2
Using NZ Function to return ALL records 4
Query Problem 2
Blank Fields in NOT Null Query Criteria 5
Query Confusion 16
Preferred way to do sort order - column in table, or specified in query? 3
determining if a field should be included 6
Prevent query from changing number values to text values 6

Back
Top