Using a date for a detail page criteria

[smurf01]

I have an asp page that shows the total number of future orders by date, they are grouped by date and summed by number of orders. what I was hoping to do was to create a detail page that would be populated by using the date column as the parameter however whenever I try it i keep getting a data type mismatch error in the criteria expression. I am using an Access DB to get the data from.

Regards

Paul

 

[smurf01]

OK soted it now i had to put # either side of the date criteria i.e.

WHERE DueDate = #Ddate#

Regards

Paul