I think this should work :

Code: SQL
SELECT *
FROM Ledger
WHERE TranDate BETWEEN #1/1/2008AND #1/1/2009#
ORDER BY TranDate;
I think you have used Oracle or SQLServer earlier, so you used quotes. But the delimiter in MS Access is # not '

Last edited by SaswatPadhi; 2Jun2009 at 17:15..