sorry its only worth 70 points - its all i have! will bump iut up as much as i can when i accept the answer!
Can anybody tell me why this doesnt work?
sql = "SELECT * FROM table WHERE (myDate BETWEEN #"&date_1&"# AND #"&date_2&"#);"
the ouput sql is
SELECT * FROM productionSheet WHERE myDate BETWEEN #27/03/2006# AND #01/07/2006#;
the asp page doesnt crash out, but doesnt retrieve any of the data i am expecting it too.
the myDate field in the access db is a date/time datatype and is of a general format.