expression builder and sum function

[Desiree Haubner]

I have a very simple database with a field for name and
then a number field for payments made each month of the
year. I am trying to get a sum for the year to appear for
each record or person. I keep getting a SUM for all
records. How do I get the SUM for individual records?

Thanks

 

[chuck]

Generate a report. Use the report Wizard and choose the
table or query containing the data. When the Wizard ask
for a grouping choose group by name. Once the report is
completed, go into design view and copy and paste the
payments field into the report. This will give two
payments fields. Go to the properties of the second
payment field and choose 'running sum' and 'by group'.
Now you will have payments and total payments on the
report grouped by name.

There may be other ways but I think this is easiest.