pdvsa
asked on
#Error in query, Date
experts, I get a #error in the attached query. I know the reason but I dont know how to fix. If you delete the date in [UltimateExpirey] then the #error goes away.
here is the calculation:
NotifyByDate: IIf([DateOfExpirey]<[UltimateExpirey],[DateOfExpirey]-Format(N z([tblAuto Extend_Eve rgreen].[D aysNotice] ,0),"m/dd/ yyyy"),For mat([DateO fExpirey]- Nz([tblAut oExtend_Ev ergreen].[ DaysNotice ],0),"m/dd /yyyy"))
Please open attached and open the query "error". There are 2 tables and 1 query.
thank you.
EE.accdb
here is the calculation:
NotifyByDate: IIf([DateOfExpirey]<[UltimateExpirey],[DateOfExpirey]-Format(N
Please open attached and open the query "error". There are 2 tables and 1 query.
thank you.
EE.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pdvsa,
Make sure that logic is correct! It is not configured exactly like your IIF() statement was.
Have a good weekend.
Dale
Make sure that logic is correct! It is not configured exactly like your IIF() statement was.
Have a good weekend.
Dale
ASKER
Fyed, yes, I discovered I had to tweak it just a bit. It works great! Thank you
ASKER