Calculated Field from Form to Table

[MarcusS]

Hello,

I have been reading various threads about this subject and I know that one shouldn't store a calculated field in a table.

I believe this may be an exception to the rule (but I could be wrong).
I am making a pricing database that will use a few manual inputs and the rest of the fields will be calculations (gross/profit margin, expenses) based off these inputs. We need to have these calcuated fields stored because they are essential to the pricing decisions and we will have to go back and access these fields at a later time. Another reason for this is because there will be at least one report that will be used to compare prices and calculated fields associated to a certain product by company, program, item type, ect...


Any help would be greatly appreciated.

 

[ejstefl]

I'm not sure what the question is?

 

[MarcusS]

The question was in the title of the thread: Post a calculated field done in a form to a field in a table.

The problem was that the form was based on a table.
The solution I used was to make a query that took the fields in the form and appended them to the table. Probably not the most efficient solution, but it seems to work so far.