Report query / filters

[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

 

[Jerry Whittle]

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

Null
Null
Null

 

[Marshall Barton]

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.

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