If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Long list of fields, how to check if either is null
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... |
#2
|
|||
|
|||
Long list of fields, how to check if either is null
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 |
#3
|
|||
|
|||
Long list of fields, how to check if either is null
Well that was easy! :-)
On 27 apr, 14:15, "Krzysztof Naworyta" 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 |
#4
|
|||
|
|||
Long list of fields, how to check if either is null
On Tue, 27 Apr 2010 04:37:39 -0700 (PDT), 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... 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] |
Thread Tools | |
Display Modes | |
|
|