Morris Guitars Serial Number. See solution in other versions of Access: • Question: In Microsoft Access 2003/XP/2000/97, I'm trying to write a formula in a query as follows: [Price]/[Quantity] Most of the times this formula works, but in some cases the [Quantity] field is zero so when the formula divides zero by zero, the result comes up as #Error. Is there a way I can tell Access, if dividing by zero, the result is zero? Answer: You can use the in your Access query to handle these cases. We'll demonstrate how to do this with the example below. In this example, we've used the to return 0 if the [Quantity] is 0. Otherwise, it would return the value of [Price] divided by [Quantity]. This is achieved with the following formula: IIf([Quantity]=0,0,[Price]/[Quantity]) Now, your Access query should no longer return an error when a [Quantity] of 0 is encountered.

I am hoping someone may be able to spot the error in my expression below that is resulting in the 'Overflow' Access 2007 error message: Collection Percent: -Round(IIf([Production]. I don't think so, but it wouldn't be the first time I was wrong. Download Lagu The Overtune Sayap Pelindungmu. Not even the first time today. I don't agree with ' then if Production is >1 PP could still be 0 and that is the problem'. With the OR test, if PP is 0 then the condition is True and 0 should be returned, regardless of the Production value.