By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,312 Members | 1,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,312 IT Pros & Developers. It's quick & easy.

Testing against a blank field

P: n/a
Hi:

I have a trivial but frustrating question. I have a record and have set up a query against
it, but I cant get it to work!

I wish to select the record IF a specific date field is blank. I somehow cant find the
right formulation in a query to do that. Can someone point me in the right direction,
please

Thanks in advance.

Regards

John Baker
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
John:

Try putting Is Null in the criteria for your query.

Jana

Nov 13 '05 #2

P: n/a
Jana:

Thank you. I was certain there was a simple solution that would work! I just did not know
what it was.

Thanks a again

John

"Jana" <Ba********@gmail.com> wrote:
John:

Try putting Is Null in the criteria for your query.

Jana


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.