Hi
I'm new to the forum, and new to Access in general really.
I have the following query, but receive a "division by zero" error if LY_PICKUP is zero. So, I'd like to always return a value of 1 if LY_PICKUP is zero, as it does if it encounters a "null"....but not sure how to do it!
PICKUP: Round(IIf([LY_PICKUP] Is Null,IIf([VAR_PICKUP]<0,-1,1),[VAR_PICKUP]/[LY_PICKUP]),4)
Any assistance is appreciated
Thanks
Tim