i am using dao in some simple in line sql. what I am trying to do is create a recordset of two fields with the condition that the date field falls between two dates. in the db the date field IS declared as a date. Here is my sql string:

SELECT Hours, PayDte
FROM EmployeeHours
WHERE PayDte
BETWEEN 'somedate' AND 'somedate'

pretty simple, however i get a data type mismatch error when i execute this. its is driving me insane and i am stuck until i figure it out. thanks in advance for any suggestions

jj