criteria for an empty date

Hi,
History: In my database I fill in a record for a product but not the date
field until the product is completed. My reports will not show this data
because I enter a criteria of Like "*/*". What I want to do is have a query
that will show me only the records that don't have the date filled in so I
can keep track of which ones have been entered and which ones haven't.

Question: How do I write criteria that will give me only the empty dates?
I have tried Not Like "*/*" but it doesn't work. I don't get any records
returned and I have at least three with empty dates.

Thanks for your help,

June

Where NameOfDateField IS NULL

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


"June" wrote in message
...
Hi,
History: In my database I fill in a record for a product but not the date
field until the product is completed. My reports will not show this data
because I enter a criteria of Like "*/*". What I want to do is have a
query
that will show me only the records that don't have the date filled in so I
can keep track of which ones have been entered and which ones haven't.

Question: How do I write criteria that will give me only the empty dates?
I have tried Not Like "*/*" but it doesn't work. I don't get any records
returned and I have at least three with empty dates.

Thanks for your help,

June

In the Criteria row of your query, under the date field enter:
Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"June" wrote in message
...
Hi,
History: In my database I fill in a record for a product but not the date
field until the product is completed. My reports will not show this data
because I enter a criteria of Like "*/*". What I want to do is have a
query
that will show me only the records that don't have the date filled in so I
can keep track of which ones have been entered and which ones haven't.

Question: How do I write criteria that will give me only the empty dates?
I have tried Not Like "*/*" but it doesn't work. I don't get any records
returned and I have at least three with empty dates.

Thanks for your help,

June

Thank you, that worked. And it was so easy too.

June

"Allen Browne" wrote:

In the Criteria row of your query, under the date field enter:
Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"June" wrote in message
...
Hi,
History: In my database I fill in a record for a product but not the date
field until the product is completed. My reports will not show this data
because I enter a criteria of Like "*/*". What I want to do is have a
query
that will show me only the records that don't have the date filled in so I
can keep track of which ones have been entered and which ones haven't.

Question: How do I write criteria that will give me only the empty dates?
I have tried Not Like "*/*" but it doesn't work. I don't get any records
returned and I have at least three with empty dates.

Thanks for your help,

June