You have to delimit the date string with # signs:

WHERE cprduedate = #mm/dd/yyyy#

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
wrote in message
hlink.net...
hi everyone!
does anyone know how to filter a recordset for a specific date.
for example. i keep some dates in an access database of cpr training. i am
making a repeating region listing the people whose cpr license will expire
in 30 days. well how do you construct that kind of sql sentence
SELECT*
FROM table
WHERE cprduedate = what
i'm completely lost! i keep dates in form mm/dd/yyyy and am using asp.
thanks a bunch in advance