Query Sum Amount To Table Field

  • Thread starter Thread starter HMCBDS
  • Start date Start date
H

HMCBDS

Greetings...

I have one row of data which each field in that row is numeric. The last
field in the row would be the sum of those numeric values. I was able to
calculate that sum in the Form and Query View. But how does one take the
Grand Total Sum from the query or form so it will appear in my last field in
the Table Object view.

Thank you in advance!

mc
 
You don't!

Calculated data such as this (with rare exceptions) should not be stored in
a table. Just do the calculations like you already are, in a query field
or a calculated control on a form/report.
 
Back
Top