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?

Sum(Cdec(Nz([TotalPrice]/([tbl_ArticlesPerOrder]![Amount]*[Total])*[tbl_ArtikelRemoveFromSawList]![Amount]),0))

EDIT: Removing the TotalPrice division removes the overflow. So I suspect a division by 0. Any way to deal with that?

Answers


I would try to see if you can build an IFf statement within your sum to handle the division by zero.

e.g.

IIf([tbl_ArticlesPerOrder]![Amount]*[Total])=0,0,[TotalPrice]/([tbl_ArticlesPerOrder]![Amount]*[Total])

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: http://restlet.com/technical-resources/restlet-framework/guide/2.3/core/services/log), 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.