Sum on subform error

[BradCollins]

I have searched and searched and cannot find anything that would help explain my problem.

I have a continuous subform with a field (fldNetValue) on it, in the form footer I want the total, so obviously the answer is to have a calculated field with a value of '=Sum([fldNetValue])' of course this works on one of my subforms, but on the other i just get the #error response.

Can anyone help shed some light on this and why it is occuring ?

Thank you

 

[missinglinq]

Is [fldNetValue] entered physically in the records or is it a calculated value? You can't use Aggregate Functions against calcualted fields, you have to use them against the expressions used for the calculations.

In other words, if

FieldC = FieldA - FieldB

you cannot use

=Sum(FieldC)

you have to use

= Sum(FieldA - FieldB)

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[BradCollins]

fldNetValue is taken direct from the table so not calculated, not sure what the problem was, but a compact/rebuild seems to have done the trick.

Thanks for your help

 

[missinglinq]

Glad you got it fixed!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!