How to create a field to calculate value which obtained value from different table

[zool]

Hi,

I'm trying to summarize the value from multiple fields in a table and the total value will be updated on a different table as per highlighted below (taken from Northwind Web Database). Anybody could help me on this?


Thanks.

[June7]

You want to sum the values of multiple records then save to table? Saving aggregate data is usually not a good idea. Calculate aggregate data when needed.

[zool]

If that is the case, how should I do it without having to save the aggregate data?
I have tried the query method but the value of aggregate data shown on empty form when the value supposed to be zero.

[stmoong]

If that is the case, how should I do it without having to save the aggregate data?
I have tried the query method but the value of aggregate data shown on empty form when the value supposed to be zero.

Try setting the Sub Total control to a formula, something like =Sum([Order Details]![Total Price])

You might need to check what is the name of the controls to get it working.