Of course...a Date Question

[ffowler]

Good day to you all.
I have a question that I am hoping to get a hint on.
I have a field that is an expiration date. At any one time, only one row should have a blank expiration date field, all other rows(for the same product let's say) should have this column populated.

I now want to pull only those records, which are not expired (blank column) but I keep receiving an error on my query, whenever I use "", " ", '', or ' ' in the criteria.

My question is, how can I retrive only non-expired rows?



Thank you in advance for any help you can offer.

F

[alansidman]

In the criteria put IsNull

Alan

[ffowler]

Not sure how to mark this SOLVED, but it is. Thanks Alan!!

[alansidman]

In the original thread, click on Edit. Then Go Advanced. I think there will be an opportunity in the upper left to mark it solved.