I have two different versions of a query.
Code:
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
Code:
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