J.R. Sitman
asked on
Microsoft Access query help
I need this query modified to only give me those softslips where the action date is 14 days prior to the availability date.
PARAMETERS [forms]![frmswitchboard]![ txtStartDa te] DateTime, [forms]![frmswitchboard]![ txtEndDate ] DateTime; SELECT SoftSlip, Species.Species,Availabili ty, actiondate, SoftSlips.Location FROM Species INNER JOIN SoftSlips ON Species.SpeciesID = SoftSlips.SpeciesID WHERE (((SoftSlips.ActionDate) Between forms!frmswitchboard!txtSt artDate And
forms!frmSwitchboard!txtEn dDate) And ((SoftSlips.ImpoundCode) Not In
("ocsd","pcd","ocrd","acor d","acosd" )))
and location = "South Bay" AND Availability > ActionDate order by species
PARAMETERS [forms]![frmswitchboard]![
forms!frmSwitchboard!txtEn
("ocsd","pcd","ocrd","acor
and location = "South Bay" AND Availability > ActionDate order by species
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
glad to help.
ASKER