BASIC Query Criteria Assistance Reqrd

[dubbel00]

Forgive the possible faux pas in my question but I'm a newbie to Access, a quick learner but newbie all the same...

Q. How do I denote a Criteria that says:
&quot; Between DOB and Datestart <= 2 months &quot; where we have tables of Birthdates (DOB) and a start date for health visits (datestart) and alls I wanna do is list all those who were visited within 2 months of their birth.
It's Community Health Thang so it'd be nice to get a response even though it's basic. Promise I won't hassle the respondent!!!

 

[jebry]

Hi!

In the criteria section for the DOB put:

<=DateAdd(&quot;m&quot;,-2,[DateStart])

I think that should work, but I haven't tested it.

hth
Jeff Bridgham