I am trying to access all reservation held in a Access 2000 database between two dates.. i am using the following query
WHERE Reservation.Development_ID = Plot.Development_ID AND Reservation.Plot_No = Plot.Plot_No AND (Plot.Current_Build_Stage = Build_Stage.Current_Build_Stage) AND Plot.Development_ID = 'BIDE001' AND (Reservation.Reservation_Date BETWEEN '#datefrom#' AND '#dateto#')

This will work when i enter dates into the query, but as the user is specifying which dates to search between, i need to use a session. I have specifed the two sessions weekend and weekstart, but keep recieving a data type mismatch in criteria expression error...

Any help would be fantastic..
thanks
Claire