Criteria Query help

[imintrouble]

Hello,

after searching around on google for a second, I found the Microsoft page on how to create criteria. This was all good and great but I'm still in the dark about how to create a set of criteria which will only display records where one column has a date entered AND where there is no date in a different column.



So basically it will only show the record if COLUMN-A has a date there AND if COLUMN-B does NOT have a date entered.

This way, the moment COLUMN-B recieves a date, it no longer appears in this query.

Thanks!

Imintrouble

[aytee111]

In the query design, in the criteria row, under A put "Is Not Null" and under B "Is Null"

[imintrouble]

Haven't tried that yet but i'm sure it will work. Thanks much!