|
| 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
April 27th, 2010, 12:37 PM
posted to microsoft.public.access.queries
|
|||
|
|||
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
April 27th, 2010, 01:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
April 27th, 2010, 01:21 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
April 27th, 2010, 05:42 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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 | |
|
|
Linear Mode
