Want Query to find records with an empty date field

[tim1234]

I have a query that I want to show only records that do not have a value in the DateClosed field. I'm not sure which expression I need to use. Any help is greatly appreciated.

 

[sfreeman@co.mer]

Something like this?


SELECT
tblDates.Date

FROM
tblDates

WHERE
(((tblDates.Date) Is Not Null));

HTH

 

[raskew]

Hi-

To return just those records where there's not a date, you'd use the reverse of the previous response, e.g.

SELECT tblHolidates.theDate, tblHolidates.Holiday
FROM tblHolidates
WHERE (((tblHolidates.theDate) Is Null));

HTH - Bob

 

[tim1234]

Where to put the code.

Do I put that in the expression builder or in a module? Kinda new at this. Thanks for your help.

 

[Ukraine82]

What raskew gave you was a query sql. All you have to do is make a query with selected fields and for DateClosed field criteria type in is null.

hth,
Michael

 

[tim1234]

thanks!!!!

thanks for the help guys!!!