Sum on Subform

[warway]

I have an MSA2000 project with a subform that will not total detail records
when there is a calucation involved in the detail part of the form.

Subform contains data from a view and contained on the form are combo boxes
with a column to use to calculate the total I want to sum.

The detail records calculate the right amount but the sum of this value in
the subform footer gives me #error.

If I just total the vaule in the on the subform without the calculation I
get a correct sum in the footer.

If I have any calulations taking place in the detail records the sum
function in the footer fails with #error

What am I doing wrong?

TIA

Warway

 

[Kelvin]

The sum function only works on actualy fields not text boxes. So if you
have a field like Amount then Sum(Amount) will produce the correct result.
If you have a calculation like Total=Amount*5 then Sum(Total) will not work.
You need to refer to the actual fields. Sum(Amount*5) will works.

Kelvin