Hello all. I am having trouble upon adding another WHERE clause to my statement:

 
rsEmpTime.Source = "SELECT *  FROM tblEmpTime  WHERE dbEmpLogin = '" + Replace(rsEmpTime__MMColParam, "'", "''") + "' AND WorkDate = '" & testdate & "'  ORDER BY Counter ASC"

Before adding the 'AND WorkDate' portion, it worked fine, but now I am getting the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Any suggestions?

Thanks,

Parallon

Ok, if i change the code to filter for a specific date, it seems to work, but I can't use the variable on that page called 'testdate' to compare. Here is the code that does work:

 
rsEmpTime.Source = "SELECT *  FROM tblEmpTime  WHERE dbEmpLogin = '" + Replace(rsEmpTime__MMColParam, "'", "''") + "' AND WorkDate = '3/22/2006'  ORDER BY Counter ASC"

Also, I had to set the field type in the database to 'text'.

Thanks,

Parallon

I finally got it. I found out that I had my recordsets out of order.

thanks,

Parallon

date variables in access need date literals "#" wrapping around them