Need help with IIf statement

[JackieEVSC]

I have a query that pulls in info for student netbooks. One model of netbooks has some units that are not under warranty. I am having trouble getting this query to work as needed. I know it's some silly syntax issue I can't see.

The query returns results for all assets with one of 6 AssetTypeID's. Only one of those asset types have warranty issues (227754). I need the IIF statement to return 'THIS UNIT IS NOT UNDER WARRANTY' if the AssetTypeID is 227754 and the InsSvcTag field is empty. The statement below gives me '#ERROR' on the ones that fit the criteria. What am I doing wrong?

Warranty: IIf([62-StudentWarranty]![AssetTypeID]=227754&[62-StudentWarranty]![InsSvcTag]=Null,"THIS UNIT IS NOT UNDER WARRANTY","")

 

[JackieEVSC]

Oops ... if the AssetTypeID is 227754 and the InsSvcTag field is empty I get #Error ... if the AssetTypeID is 227754 and the InsSvcTag field is empty I get nothing

 

[PHV]

Warranty: IIf([62-StudentWarranty]![AssetTypeID]=227754 And Trim([62-StudentWarranty]![InsSvcTag] & "")="","THIS UNIT IS NOT UNDER WARRANTY","")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886