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
|
|||
|
|||
access criteria
Access 2000: I have the following query
Last | First | columnA | columnB | columnC In the criteria field I need to build an expression: ColumnA ColumnB ColumnC x 0 0 0 x 0 0 0 x x x 0 0 x x x 0 x x - not null (text field) 0 - null I need to show names of clients, if one of the condition above is true or not to show if all of them null. thank you for your time. |
#2
|
|||
|
|||
Hi Tom,
Hope I didn't read this wrong. It seems like you want to show the client names if any column is not null? If so, you would want your query grid to look like: Last First ColA ColB ColC X X X X X criteria not is null not is null not is null -----Original Message----- Access 2000: I have the following query Last | First | columnA | columnB | columnC In the criteria field I need to build an expression: ColumnA ColumnB ColumnC x 0 0 0 x 0 0 0 x x x 0 0 x x x 0 x x - not null (text field) 0 - null I need to show names of clients, if one of the condition above is true or not to show if all of them null. thank you for your time. . |
#3
|
|||
|
|||
On Tue, 17 Aug 2004 09:26:53 -0700, "Tom"
wrote: Access 2000: I have the following query Last | First | columnA | columnB | columnC In the criteria field I need to build an expression: ColumnA ColumnB ColumnC x 0 0 0 x 0 0 0 x x x 0 0 x x x 0 x x - not null (text field) 0 - null I need to show names of clients, if one of the condition above is true or not to show if all of them null. thank you for your time. Try a criterion of WHERE (ColumnA IS NOT NULL OR ColumnB IS NOT NULL OR ColumnC IS NOT NULL) Equivalently, on the query grid, put IS NOT NULL under each of the three columns on *different* grid rows (which will force OR logic). John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#4
|
|||
|
|||
wow, that was easy.
thank you Les, -----Original Message----- Hi Tom, Hope I didn't read this wrong. It seems like you want to show the client names if any column is not null? If so, you would want your query grid to look like: Last First ColA ColB ColC X X X X X criteria not is null not is null not is null -----Original Message----- Access 2000: I have the following query Last | First | columnA | columnB | columnC In the criteria field I need to build an expression: ColumnA ColumnB ColumnC x 0 0 0 x 0 0 0 x x x 0 0 x x x 0 x x - not null (text field) 0 - null I need to show names of clients, if one of the condition above is true or not to show if all of them null. thank you for your time. . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access user profile | Michael Breitsameter | General Discussion | 7 | July 23rd, 2004 07:47 AM |
Informal testing of Access 97 Skills | david epsom dot com dot au | General Discussion | 7 | July 13th, 2004 01:36 PM |
Error while running Access MDE | Hemil | General Discussion | 2 | June 21st, 2004 01:03 PM |
DSUM Criteria and Excel Help | Earl Kiosterud | Worksheet Functions | 2 | April 30th, 2004 07:55 PM |
writing criteria in access and using pivot in excel | Frank Kabel | Worksheet Functions | 2 | March 23rd, 2004 04:35 PM |