Query for missing date?

B

Bob H

I have a database where a date needs to be entered for records, ie
DateReceived. If the date text box is blank; no date entered, I need to
track that by having a query which will tell me if the date has not been
entered.
I was thinking about the Where clause, something along the lines of
where DateReceived=, and that is where I come to a stop, because I am
not sure of the syntax, if at all this the right way to go.

Is there another way I should go to find missing dates or a different
clause to use.

Thanks
 
B

Bob H

Update, I found out how to do what I wanted. 'Is Null' on the date field
gives me what I want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top