Summing in a form!

[MARIEACCESS]

i have a user page which has a total of their amounts loaded and redeemed
when I try and sum the values its displaying a sum for all records not for
the record currently viewed. (In detail section) I cant group in the query
because then the form will not enable editing. Is thre somehow I can sum per
record not for all. Or is there another way around enabling the form to be
editable is the query has a calculation in it?

 

[John W. Vinson]

i have a user page which has a total of their amounts loaded and redeemed
when I try and sum the values its displaying a sum for all records not for
the record currently viewed. (In detail section) I cant group in the query
because then the form will not enable editing. Is thre somehow I can sum per
record not for all. Or is there another way around enabling the form to be
editable is the query has a calculation in it?

Is this an Access Form? or a "page" (Data Access Page or what)?

If it's an Access Form, you can use a Continuous Form; make its header or
footer visible, and put a textbox on the subform with a control source

=Sum([fieldname])