J.R. Sitman
asked on
Microsoft Access Query help
How do I add "and availability is not null" to the bold line below
strFormCrit = Nz(Me.OpenArgs, "1")
strCritBase = strFormCrit & " AND ImpoundCode IN('OCS', 'OCST','ACOS','ACOST')"
strCritWithID = strCritBase & " AND Availability > (ImpoundDate +7)"
strCritNoID = strCritBase & " AND Availability <= (ImpoundDate +7)"
strFormCrit = Nz(Me.OpenArgs, "1")
strCritBase = strFormCrit & " AND ImpoundCode IN('OCS', 'OCST','ACOS','ACOST')"
strCritWithID = strCritBase & " AND Availability > (ImpoundDate +7)"
strCritNoID = strCritBase & " AND Availability <= (ImpoundDate +7)"
ASKER
My mistake,
What I need is "Give me all the animals where the Availability date is greater than 7 days past the impound date and also include those where the Availability date is null.
What I need is "Give me all the animals where the Availability date is greater than 7 days past the impound date and also include those where the Availability date is null.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ASKER
Never mind. It was missing the end )
Working
Working
ASKER
Thanks
or
strCritWithID = strCritBase & " AND Nz([Availability],#1/1/190