I don't think you could have done.
I changed it to Long integer and then this query works.
I haven't been able to upload a file, for some reason.Code:SELECT TireData.MyMonth, TireData.Quantity, IIf([quantity]-3=1,"Yes","No") AS Expr1 FROM TireData;