Pulling dates

[Guest]

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

 

[Al Campagna]

Antney,
Try
IsNull
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Perfect.

Thanks Al

Antney

Antney,
Try
IsNull
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."