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.



MS LINK: Avoiding divide by zero errors in Access

(Edited based on Kev's comments)

Need Your Help

LNK2005, “already defined error” linker error in MSVC2010

c++ visual-studio-2010 compiler-construction point-clouds

I am trying to implement a test project using the Point Cloud Library and OpenCV with multiple files. When I try to compile, I get the "already defined error" message. Probably I'm doing something ...

How can I change the default log template in a restlet application?

logging restlet

The Restlet documentation is a bit vague on this. It describes the default template that's used (at:, but provi...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.