Percentage base on two previous fields.

[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 DEWEY]

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

 

[Dan Johnson]

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

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

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.