Hi,
I am recieving the following error message when I try to do a BETWEEN statement in VBA Access.
'Data type mismatch in criteria expression'
My statement is :
RDate is a datetime format in SQL and LStartDate and LEndDate are textbox's in access with Shortdate format.Code:LStartDate = Me.txtStartDate.Value LEndDate = Me.txtEndDate.Value LSQL = SELECT RDate, Site WHERE RDate BETWEEN '" & LStartDate & "' AND '" & LEndDate & "'
thanks