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.