Hi,

I have this query:

SELECT COUNT(appold.reason) AS Insufficient_Information
FROM appold
WHERE appold.reason LIKE 'Insufficient Information' AND (appold.`date out`
BETWEEN MMColParam1 AND MMColParam2)

MMColParam1 #01/01/2003# Request.QueryString("date1")
MMColParam2 #20/01/2003# Request.QueryString("date2")


and using this link to set the values:

page1.asp?date1=#01/05/2003#&date2=#30/05/2003#

When I test this in the recordset dialog it shows up with the correct count but when I use the link as above I get a 0 count, what am I doing wrong?

I'm using Dreamweaver and Access

Regards,

Sanjay