Microsoft Access query help

How do I change this query to give me animals adopted whose age is 4 months or less.  currently is only list those less than 4 months old


SELECT Count(SoftSlips.SoftSlip) AS CountOfSoftSlip
FROM Species INNER JOIN (SoftSlips INNER JOIN Adoptions ON SoftSlips.SoftSlip = Adoptions.SoftSlip) ON Species.SpeciesID = SoftSlips.SpeciesID
WHERE (((Species.Species)="dog") AND ((Adoptions.AdoptionDate) Between [forms]![frmSwitchboard]![txtStartDate] And [forms]![frmSwitchboard]![txtEndDate]) AND ((DateDiff("m",[DOB],[AdoptionDate]))<4) AND ((SoftSlips.Location)="long beach"));
J.R. SitmanAsked:
Who is Participating?
 
dustockConnect With a Mentor Commented:
change <4 to <=4
0
 
J.R. SitmanAuthor Commented:
Thanks
0
 
dustockCommented:
No problem
0
All Courses

From novice to tech pro — start learning today.