Filtering based on form dates

[cbh35711]

I have two different versions of a query.

SELECT Approval_status, ModDate AS [Date], borrower, Acct_reference_IDFROM report_log2
WHERE ModDate Between Forms![Select Dates]!Start_date And Forms![Select Dates]!End_date
ORDER BY ModDate DESC;

and

SELECT Approval_status, ModDate AS [Date], borrower, Acct_reference_ID
FROM report_log2
WHERE ModDate Between "#" & Forms![Select Dates]!Start_date & "#" And "#" & Forms![Select Dates]!End_date & "#"
order by ModDate Desc;

I thought it was filtering correctly, but it appears it is not.

Any assistance would be greatly appreciated.

Chris

[cbh35711]

Still trying to figure it out.

When hard coding the dates, i'm getting that the data type mismatch in criteria expression.

WHERE ModDate > "#1-1-2012#" And ModDate < "#1-31-2012#"

Thanks all

Chris

[orange]

What exactly are you trying to do?
Is ModDate a Date/Time datatype?
Date is a reserved word in Access.
You don't need " delimiters on a Date/Time type

[cbh35711]

You nailed it Orange. No "". So easy...

Thanks