I have a table with timestamp as one of the columns. I am having to use a passthrough query on this table to get a few other fields which are not available on the access front end. Now i am trying to filter those records based on a date range. But the passthrough wont let me give the date range! This is what i tried:
Code:
SELECT intake_taken, staff_7, accept, Reason_for_Rejection_party
FROM DBA.case_intake
WHERE matcode = 'S S' AND accept='N' AND intake_taken BETWEEN '06/01/2011 00:00:00 AM' AND '12/01/2011 00:00:00 AM';
2nd try:
Code:
SELECT intake_taken, staff_7, accept, Reason_for_Rejection_party
FROM DBA.case_intake
WHERE matcode = 'S S' AND accept='N' AND intake_taken BETWEEN '06/01/2011' AND '12/01/2011';
I also tried
Code:
SELECT intake_taken, staff_7, accept, Reason_for_Rejection_party
FROM DBA.case_intake
WHERE matcode = 'S S' AND accept='N' AND intake_taken BETWEEN #06/01/2011# AND #12/01/2011#;
Nothing works! How can i get the query to read the date range??
Your thoughts and time are appreciated.
Kris