trouble with "Date" expressions

  • Thread starter Thread starter Ron Sutherland via AccessMonster.com
  • Start date Start date
R

Ron Sutherland via AccessMonster.com

I am a new Access user so please pardon my basic question. I have created a DB that I wish to manipulate the input dates. Specifically I am looking for an expression to put in the criteria section that will use the current date on the computer and include all data within 90 days of that date. I spent the past couple of days beating my head against the wall and getting no where, even my ACCESS book for dummies didn't help much.

Thanks for any help.
Ron
 
Set the criteria under your date field to something like:
Between DateAdd("d",-90, Date()) and DateAdd("d",90,Date())
 
Thank you so much,it worked perfectly!

Best Regards,
Ron
 
Back
Top