Long list of fields, how to check if either is null

[atledreier]

I have a query with 10 fields.

I need the query to return only the records where one of the 10 fields
is NULL. The design window only allow 8 'levels' of criteria...

 

[Krzysztof Naworyta]

atledreier wrote:
| I have a query with 10 fields.
|
| I need the query to return only the records where one of the 10 fields
| is NULL. The design window only allow 8 'levels' of criteria...

Menu: Insert > Rows

 

[atledreier]

Well that was easy!

 

[John W. Vinson]

I have a query with 10 fields.

I need the query to return only the records where one of the 10 fields
is NULL. The design window only allow 8 'levels' of criteria...

32 actually if you insert rows...

One trick (which works with Number or Text fields) to do it in one criterion
uses the fact that the + operator adds numbers, or concatenates strings, but
also propagates NULLS - so you can include a calculated field

AnyNull: [A] + + [C] + [D]

and use a criterion of IS NULL on it. The concatenation will be NULL if any
one of the elements is NULL.