Calculations

[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.

 

[Gary Walter]

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.

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

 

[fredg]

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,
Exp:IIf(IsNull(),[A],[A]-)