MS Access Overflow - Not resolved
I have the following expression in an MS Access Query, where some of these values can be null and despite the cast to a Decimal and the Not Zero (NZ) function, I still get an overflow error.
I hope someone can help me find the bug?
EDIT: Removing the TotalPrice division removes the overflow. So I suspect a division by 0. Any way to deal with that?
I would try to see if you can build an IFf statement within your sum to handle the division by zero.
(Edited based on Kev's comments)