Query of Date/Time field 2

[rlf1957]

I have a table defined with a date/time (short date) field.
The table has a large number of empty fields do to a mistake building its form. What I would like to do is search for these records with an update query to plug in a meaningful date to these fields.
The values in the field start at 01/01/04, and I am able to select any date range that I want but Field="" returns nothing and Field < 01/01/04 also returns nothing.
Any help with a method to 'find' these empty records using a query would be appreciated.

 

[SkipVought]

Hi,

How 'bout NULL?

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[PHV]

And this ?
Field Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rlf1957]

Thanks much SkipVaught and PHV. Don't I feel dumb. I certainly thought that I had tried "Null" already. Guess I must have used it improperly because it worked both ways.
Thanks again.

RLF