Summing in a form!

  • Thread starter Thread starter MARIEACCESS
  • Start date Start date
M

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?
 
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?
Click to expand...

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])
 
Back
Top