I have a query with a formula:
BendTestsReq: IIf(Val([SageBTLot])=0,"",(IIf(Val([JO_Qty])<Val([SageBTMin]),Val([SageBTMin]),(Val([JO_Qty])/Val([SageBTLot]))*Val([SageBTQty]))))
When I run the query, it shows the correct value:
When I add the field to my form, it shows this:
Not sure what is happening here. on the form it is setup as a general number with zero decimal points.
Thanks!
Jennifer