Why Access can't recognize Sum([value]) on report footer ?

[awinnn]

Hi,
I have RefNo, StaffName and Amount. I've created RefNo header and footer on the report. RefNo will be on the RefNo Header, while StaffName and Amount on the Detail and differentiation of Amount on the RefNo Footer.
My problem is to get total of the differentiation on the Report Footer.

This is the differentiation, txtDiff,
=IIf(Count([Amount])>1,Max([Amount])-Min([Amount]),[Amount])

If i put on the Header Footer like this,
=Sum([txtDiff])

it doesn't work..it doesn't recognize the txtDiff.
any idea? thanx in advance..

 

[CosmoKramer]

Access won't let you sum calculated controls, you have to recalculate them in the footer. Try:

=Sum(IIf(Count([Amount])>1,Max([Amount])-Min([Amount]),[Amount]))

Hoc nomen meum verum non est.