Copy the result of an automated calculation into a table from a fo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My main form is based on a table. I created a query based on two tables. From
this query I created a subform in my main form.
The subform executes an automated total (calculation), I need to copy this
value into my original table. What should I do ? I did not create a field in
my table for this value.
Help !!!
Thanks
 
First, it is rare that you will need to save a value that can be
(re-)calculated from existing data. And there are some very good reasons
NOT to do so.

Instead of having to add a field to the table, and do the calculation, and
save the value, why not just do the calculation in a query? You could use
that query to "feed" your forms and reports, so you may not need to save the
calculated value.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Makes sense. Thanks


Jeff Boyce said:
First, it is rare that you will need to save a value that can be
(re-)calculated from existing data. And there are some very good reasons
NOT to do so.

Instead of having to add a field to the table, and do the calculation, and
save the value, why not just do the calculation in a query? You could use
that query to "feed" your forms and reports, so you may not need to save the
calculated value.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
 
I have the same problem. But I need to save the value of the calculated
field for historical reasons. The database is for customer sales. And I
have to constantly compare current sales with last year to date. I have to
create quarterly reports for 19 differenct manufacturers. Some of the data I
receive is only for the current year. If I hadn't saved the data from last
year (work I already did) then I would have to re-enter it again this year in
order to do the comparisons (YTD vs Last YTD).
Even if the manufacturer does provide the last year's data, it would still
have to be re-entered in order to create the current report.
At this time, I am manually entering the calculated value into a created
field and labelled with the specific date. I then change "last year to date"
field on the report to the corresponding quarter for last year. I have no
other way to retrieve the data from last year since the calculated fields
change as soon as I enter new data for the next quarter.
At this time I am manually entering the values into that field. There has
to be a way to save just that value. Copying the field does not help. It
just copies the formula and then changes as soon as new data is entered.
 
Back
Top