Summing Groups Of Records In A Table

[tonyfrye]

I need to create a summary total of a field for groups of records in a table grouped by a "class" field in the table...then I need to update fields in the same table with the total for each group... can anyone help....thx

 

[Rich]

Use a query to calculate summary totals

 

[tonyfrye]

SUMMARIES ..... I did that.. and the query creates the ...

....totalling correctly. BUT, when I try to update the table field with the results, but the system won't let me saying the result can't be used to update another field in the same table....

Any ideas ???

THX

 

[jadair]

Reports

Is it an option to use a report?

 

[Rich]

You shouldn't store calculated fields, just calculate them when required

 

[Pat Hartman]

Aside from the fact that storing calculated values is poor practice, storing summary data in a detail table simply doesn't make any sense. Which of the detail records should hold the group total? Spend a little time rethinking your design. It would make some sense to store group totals in a table that contains only one record per group. But, this would still be poor practice since you can calculate the total easily in a query or report.