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
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.