access criteria

[Tom]

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.

 

[Les]

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

 

[John Vinson]

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).

 

[Tom]

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

.