Query Sum Amount To Table Field

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
 
B

Beetle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table calculated field Count(field) / sum(field) 0
How to calculate form field 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Sum query returns wrong results on a large table 1
Using SUM in summry Query 1
Sum 4 Fields with conditions 4
Sum in text box on form 6
Creating a sum field in access 7

Top