Calculations being done in a report

[remy]

There are calculations in a report that produces a number I need to import into several tables. The number produce doesn't not exist except when the report is generated. How or what can i do to get that number to be 'real' integer within a table. I'm so stress over this ....If have until 6/29 to make this happen.

 

[Galaxiom]

Your report is based on a query and probably an expression in the report.
Determine what these steps, calculate them outside the report and update your tables.

However as it is a derived value, do you have a good reason why you are saving this result in several tables?

 

[remy]

doing the calculations in the report was a quick way of getting the numbers to management. I actually didn't do it that way, but now I'm task with getting the numbers into the budget database. Now that the numbers have been accepted, they need to be placed in a table we use for budget historical data.
Once I calculate them outside of the report should that calculation be place in the 'criteria' line of the query. I dont want to take the chance of miskeying any of the numbers. I rather have the calculation exist in the table to avoid any $ discrepencies.

 

[Galaxiom]

If you already have a record in the destination table you need an Update query to write the new values. The value to be updated goes in the Update To line of the Update query column showing the field you want to update.

If you have to add a new record you will need an Append query.

You could actually take the numbers straight out of the report as long as it was open.
Refer to the report fields like this: [Reports]![ReportName].[ControlName]

(In my original post I was thinking more about how you would make the calculations on the fly rather than insert them into tables. This is why I suggested running the query and making the calculations independent of the report.)