Help to Sum a field on a Continuous Form

[lookforsmt]

Hi and Good evening to all,

i am trying to total a particular field [Field_Y] and show it on a Form footer, getting an error msg on control source
=Sum([Field_Y])

what am i doing wrong or is there a better way to do it through vba

Thanks Mahesh

 

[Gasman]

And the error message is?

 

[CJ_London]

does your field_Y control contain a calculation?

If so, you need to use the calculation in you summing control

. e.g. if field_Y controlsource is =qty*price you need to use

=sum(qty*price)

 

[lookforsmt]

Thanks for your response,
Yes, Field_Y contains calculation [TotalAMT]-[PaidAMT]
i tried this =Sum([TotalAMT]-[PaidAMT]), still getting error msg

 

[lookforsmt]

Appologies Gasman, for writing without using code tags.
Error msg: #Error

 

[Gasman]

Is there a value in ALL of those fields?
Try a sum of each field to isolate the issue.