Help to Sum a field on a Continuous Form

lookforsmt

Registered User.
Local time
Today, 08:46
Joined
Dec 26, 2011
Messages
672
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
 
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)
 
Thanks for your response,
Yes, Field_Y contains calculation [TotalAMT]-[PaidAMT]
i tried this =Sum([TotalAMT]-[PaidAMT]), still getting error msg
 
Appologies Gasman, for writing without using code tags.
Error msg: #Error
 
Is there a value in ALL of those fields?
Try a sum of each field to isolate the issue.
 

Users who are viewing this thread

Back
Top Bottom