Pulling dates

A

Antney

Hi,

I have a field name, in a table, with the data type as Date/Time.

I'm trying to create a query where if the field is empty, then return those
records of rows. I've already created a query if there is a date present,
"<>0", and that works fine. But when I create a query where the date, "=0",
then I get nothing. The input mask is 99/99/0000;0;_ if that means anything.

Can anyone help?

Thanks
 

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

Similar Threads

Date Mask auto changes 1916 to 2016 2
Date 4
Formatting templates 7
Data Entry Form 3
How to validate a date entered on a form 1
Dcount -Date Criteria - Won´t find it - 0
Mask requirements 1
VBA - exporting serial letters to single documents 0

Top