Percentages in forms and recording of them

[Guest]

I have a database which records and calculates the type of job my employees
do and how much of that task they have completed (in percent). these tasks
are in effect sub tasks of the main job. what i would like to is firstly:
the calculation which works out the percentage complete for the sub task is
in a form in an Unbound text box. can i some how have this calculation
recorded in a table where all the other information relating to that sub task
is recorded.
secondly: i would like that sub task percentage calculation to be then used
to calculate an over all percentage of the main task, using the results of
all the sub task percentages.
Clear as mud i know sorry

 

[Joseph Meehan]

I have a database which records and calculates the type of job my
employees do and how much of that task they have completed (in
percent). these tasks are in effect sub tasks of the main job. what
i would like to is firstly: the calculation which works out the
percentage complete for the sub task is in a form in an Unbound text
box. can i some how have this calculation recorded in a table where
all the other information relating to that sub task is recorded.

Sure, but you don't want to do that. Don't store results of
calculations, just re-calculate them as needed. (well most of the time
anyway) Normally if you store the results and one of the numbers changes,
then all the results will be wrong. Let Access recompute them anytime you
want to see or use them and they will always reflect the latest numbers and
Access almost always will compute the numbers faster than looking them up.
If you want to original results even if the numbers are corrected or changed
later, then you can store them in a table.

secondly: i would like that sub task percentage calculation to be
then used to calculate an over all percentage of the main task, using
the results of all the sub task percentages.
Clear as mud i know sorry

Again see above. Normally you would do this in a report.