Prev: Query ask for parameter value?
Next: sum weekly data into monthly
From: atledreier on 27 Apr 2010 07:37
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...
From: Krzysztof Naworyta on 27 Apr 2010 08:15
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
:)

--
KN
From: atledreier on 27 Apr 2010 08:21
Well that was easy! :-)

On 27 apr, 14:15, "Krzysztof Naworyta" <k.nawor...(a)datacomp.com.pl>
wrote:
> 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
> :)
>
> --
> KN

From: John W. Vinson on 27 Apr 2010 12:42
On Tue, 27 Apr 2010 04:37:39 -0700 (PDT), atledreier <atledreier(a)gmail.com>
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...

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] + [B] + [C] + [D]

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

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Query ask for parameter value?
Next: sum weekly data into monthly