Calculations

  • Thread starter Thread starter Tim Halpin
  • Start date Start date
T

Tim Halpin

I have a calculation which equals a figure from table A
minus a figure from table B. But when the corresponding
figure in table B isn't there, I want it to show the
figure from table A instead of the calculation. How can
this be done.
 
Tim Halpin said:
I have a calculation which equals a figure from table A
minus a figure from table B. But when the corresponding
figure in table B isn't there, I want it to show the
figure from table A instead of the calculation. How can
this be done.
Click to expand...

Hi Tim,

Are you getting Null for your calculation
when tblB.field is Null?

If so, use Nz function.

Calc: tblA.field - Nz(tblB.field)


Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
Tim said:
I have a calculation which equals a figure from table A
minus a figure from table B. But when the corresponding
figure in table B isn't there, I want it to show the
figure from table A instead of the calculation. How can
this be done.
Click to expand...
Tim,
Exp:IIf(IsNull(),[A],[A]-)
 
Back
Top