Report query / filters

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

Steve

Hi all,

I have a table that has 7 areas for input. I am trying to write a query (or
filter) that says that if ANY of the 7 areas are not filled out (Null), then
display on a report. when I put the "Is Null" language in the criteria field
for all the categories, it gives me no data because it is saying that
everyfield has to be null, when I only want it to be ANY of the 7 fields.
Can anybody help me with this??

Thaks in advance
 
Put the Null criteria one level lower in criteria grid. It would look
something like:

Null
Null
Null
 
Steve said:
I have a table that has 7 areas for input. I am trying to write a query (or
filter) that says that if ANY of the 7 areas are not filled out (Null), then
display on a report. when I put the "Is Null" language in the criteria field
for all the categories, it gives me no data because it is saying that
everyfield has to be null, when I only want it to be ANY of the 7 fields.
Click to expand...


Put each Is Null in a separate row under the criteria row.
 
Back
Top