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.
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.
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.