trouble with "Date" expressions

  • Thread starter Ron Sutherland via AccessMonster.com
  • 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
 
D

Duane Hookom

Set the criteria under your date field to something like:
Between DateAdd("d",-90, Date()) and DateAdd("d",90,Date())
 
R

Ron Sutherland via AccessMonster.com

Thank you so much,it worked perfectly!

Best Regards,
Ron
 
Top