Im using Access 2003. I have a table I need to pull out records with a current date and one year ago or more. How do I do this. Between doesn't work because it give me dates less than one year.
SELECT ACHItemsWClosedAccts.Client, ACHItemsWClosedAccts.Acct, ACHItemsWClosedAccts.DateClosed
ORDER BY ACHItemsWClosedAccts.DateClosed DESC;