Writing a form sum field to a table

[Michael]

Hi! I have a calculated field in a subform that sums the
total of invoice lines (Control Source:=Sum([Invoice
Amount]). How do I write that total to a table?

Thanks!!

Michael

 

[Jen]

Hi Michael,

You really shouldn't write this data to a table....why not
run a query and get the invoice total. In general,
calculated fields should not be stored as values in a
table. The danger is that any value that's used in the
calculation could change, but the table/field that you're
writing this info to would be static (any updates would
not be reflected). If you absolutely needed a table, you
should write a make-table query. This will ensure data
integrity.


Regards,
Jen