10-27-2011, 04:25 AM #10 MSAccessRookie AWF VIP Join Date: May 2008 Location: Central NJ, USA Access Sql Iserror For example, if evaluating falsepart results in a division by zero error, an error occurs even if expr is True.

What is knot theory about, exactly? All contents Copyright 1998-2016 by MrExcel Consulting. To come up with the Total Cost, I add them together with the following field, which works just fine: Total Cost: (Val(nz([Cost],"")))/100 + (Val(nz([Extra Cost],"")))/100 (I divide by 100 because Cost Check This Out Are you using that expression as the Control Source of a Form/Report control? –Gord Thompson Sep 30 '13 at 15:00 Both Cost and Extra Cost are stored as Text.

asked 3 years ago viewed 507 times active 3 years ago Upcoming Events 2016 Community Moderator Election ends in 6 days Blog How We Make Money at Stack Overflow: 2016 Edition If the expression is true, IIf returns one value; if it is false, IIf returns another. Therefore one bad expression can cause other calculated controls to display #Error, even if those controls are bound to valid expressions. hth, Rich Share Share this post on Digg Del.icio.us Technorati Twitter Imagine a funny saying here.

For your first query, try: IIf(IsNull([QUERY_A]![QTY1]), 0, (IIf(IsNull([QUERY_B]![QTY2]), 0, ([QUERY_B]![QTY2]*[QUERY_A]![QTY1])))) hth mcalex mcalex View Public Profile Find More Posts by mcalex 10-27-2011, 03:08 AM #5 Please, find below the function I wrote. Magic mirror madness Why write 1,000,000,000 as 1000*1000*1000 in C? Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Sign in Search