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

  • Thread starter Thread starter atledreier
  • Start date Start date
A

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...
 
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
:)
 
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...
Click to expand...

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.
 
Back
Top