Percentage base on two previous fields.

  • Thread starter Thread starter Dan Johnson
  • Start date Start date
D

Dan Johnson

I have a small database into which data is being entered into several fields. Two of these controls that are in the Form are populating the Table with the same named fields:

Number Generated
Number Completed

I would like the next control to automatically calculate, input, and display the percentage of Completed to Generated. Is there a quick way to allow the next field (Percentage Completed) to be automatically populated upon exit from Number completed divided by Number Generated. I am definitely not a good Visual Basic programmer so, if you have an answer, keep in mind you are addressing a novice.

Thanks, in advance, for your assistance.
 
Karl,

Thanks for the advice. That worked but I need to input that percentage into
a field of the table. The percentage displayed correctly on the form but I
need it to update the table. Any advice?

Thanks, again, for the help.

--
Dan Johnson


KARL DEWEY said:
Add a text box and for control source use --
=[Number Generated]/[Number Completed]*100


Dan Johnson said:
I have a small database into which data is being entered into several
fields. Two of these controls that are in the Form are populating the
Table with the same named fields:

Number Generated
Number Completed

I would like the next control to automatically calculate, input, and
display the percentage of Completed to Generated. Is there a quick way to
allow the next field (Percentage Completed) to be automatically populated
upon exit from Number completed divided by Number Generated. I am
definitely not a good Visual Basic programmer so, if you have an answer,
keep in mind you are addressing a novice.

Thanks, in advance, for your assistance.
Click to expand...
Click to expand...
 
Back
Top