
May 26th, 2003, 04:56 PM
|
|
Contributing User
|
|
Join Date: Mar 2003
Posts: 100
Time spent in forums: 13 h 12 m 50 sec
Reputation Power: 6
|
|
|
Using dates between
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
|