I need to run various queries that return records which are 5 days (6,7,8, etc) from todays date. If I put in the date 02/08/02, it would return all records with the date of 02/03/02.

Look up the DateAdd() function. You can either enter the date as a parameter, or use Date() to input today's date automatically.

Try this topic: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002959.html

HTH,
David R

Maybe I am not experienced enough, but when I use the DateAdd, it returns all with three days less on their dates. And I can't get the DateDiff to work at all. I need their orginal dates, but only of those who "joined the club" 5 days prior.

It finally dawned on me, and I understand what I needed to do! Thank you, it works now!!!