Getting result from calculated field back into table

[MTHarris]

Anyone know a way to get the result from a formula that resides in a
calculated field on a form back in a table. Result will be currency form.

Any help would be greatly appreciated

MTHarris

 

[Steve Schapel]

MTHarris,

This is a very unusual thing to do, and under most circumstances would
be a violation of data management principles. Can you explain a little
more detail about what and why?

 

[MTHarris]

well actually I have two projects.. the one that is the most critical to me
is a database which I have been making that manages data from stone testing.
the form has weingt input fields which is a series of testing sizes used for
that size stone. The weights are totaled then calculated independentally
against the total to derive a percent retained- of which is used to
calculate a percent passing. So imagine one size stone 6 sieve's/size's
that are used for that particular test. Thing is... the percent passing
which would be a calculated field is what I am needing to have shown on the
report.. not the independent weight's. The percent passing would then be
averaged and standard deviation did on it. The percent passing is the
critical data.. Also.. I know this is being lengthy.. but I already have
the report did with tons of formula's based on percent passing. I have been
able to do it because I have it based on a query which is based on a table
which has its data imported from EXCEL. I am wanting to do up a form with
the calculated fields so I can go all ACCESS and drop the excel workbooks.
Sorry so lengthy.. but it hard to explain and alot of data to me. An
average month is over a hundred samples per site.

Any further help would be greatly appreciated

MTHarris