Date Search With Query

R

Ronnie D

How do i automatically search records for dates that are 7 months old in
access, through a query, without inputing a date range every time?
 
J

Jeff Boyce

Ronnie

Take a look at Access HELP on the DateAdd() function. This will let you use
something like:

DateAdd('m',7,Date())

(actual syntax may vary).
 
R

Ronnie D

Thanks, with a little bit of research, I ended up using

Between DateAdd('m',-7,Date()) And DateAdd('m',-6,Date())

to make it work the way i wanted to, but definately needed pointed in the
right direction. thanks again for your help!!!
 
J

Jeff Boyce

You're welcome. Thank YOU for posting back your solution... it benefits any
others who are trying to do something similar.

Jeff Boyce
<Access MVP>
 
Top