Store calculated results from my query in my table

[LanieB]

HELLO!!!



I'm working with 07 so I can't use the calculated fields option in my table, SO. I have a form where they enter all the information, it then does all the calculations in my query.

Is there a way to push those calculated results from the query back into a table?

[June7]

Why would you need to? Could the calculations be done whenever needed? A principle of relational database is 'save raw data, do calcs in reports'.

Options:

1. UPDATE sql action

2. If the fields are included in the form's RecordSource, use VBA code in some event (perhaps a button click) to populate the fields:
Me!fieldname = Me.textboxname