Calculating Percentage in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that needs to calculate the percentage a certain value is
out of the whole. I also need to store the calculated percentage in a table.
How do I create an equation to calculate the percentage while using the
control source field to reference to the table I wanted to store the
calculate percentage in?
 
Ignoring the basic rule of not storing calculated values in a table, you just
need to find the best event in your code to update the value of the bound
control. The first place to consider would be the Before Update event of the
form:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Group by precinct, calculate percentage of older voters 0
Values calculated in a Form entered in the Table? 6
Access Test if value is less than percent 0
Percentage Calculation 1
Excel How to calculate percentage for time 1
Total of calculated field in a form 3
Need help on how to pass calculated field from a form to another form 0
Percentage question and query definitions 1

Back
Top