Microsoft Access Query help

I'm try to create a query to give me the animals that were impounded and their "availability date" is 14 days after the impound date.  The query below fails when I add the "part in bold"

SELECT Count(SoftSlips.SoftSlip) AS CountOfSoftSlip
FROM SoftSlips
WHERE (((SoftSlips.ImpoundDate) Between [forms]![frmSwitchboard]![txtStartDate] And [forms]![frmSwitchboard]![txtEndDate]) AND ((SoftSlips.ImpoundCode) In ("ocs","ocst","acos","acost")) AND ((SoftSlips.Availability)>("ImpoundDate"+14)) AND ((SoftSlips.Action)="rto"));

Point are high because I need this tonight.
J.R. SitmanIT DirectorAsked:
Who is Participating?
IrogSintaConnect With a Mentor Commented:
ImpoundDate should be in brackets instead.
J.R. SitmanIT DirectorAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.