store calculated field in form to table

[max1313]

Hello,
Hope you can follow me here. I have a form containing a subform (run from 2 different queries). The subform calculates an extended value ([Price]*[Qty]) for 1 or more records in the subform. The total is calculated on the main form with the following equation:

=[XYZsubform].[Form]![sumofextended] in the Control Source

This populates a calculated field with the sum of all extended values. I would like to use that calculated sum in a report. What is the best way to accomplish that? I know it's a sin, but do I need to store that value in a field in a table? Is there a VB code that I can write? Please help!

 

[CosmoKramer]

I would avoid at all costs storing a calculated value in a table, unless you want it for historical purposes.

If you already have a form/subform relationship working, you should be able to replicate the logic in a report/subreport method.

 

[max1313]

Thanks for the advise. I would actually like it for historical purposes. How could I do that?