troubleshooting Question

Make a Check equal a percentage

Avatar of gigifarrow
gigifarrow asked on
Microsoft Access
8 Comments1 Solution480 ViewsLast Modified:
hello experts I dont know if this is possible but I have  fields thatare check  marks

 once the field is checked I need it to equal a certain percentage which then is then totaled the check fields can all add up to100%'

For example:

Induction (with a check mark) =10%
Defuel(with a check mark)=20%


then as they continue to total up showintg the % until they finally show up to 100%



So do i nee d to make a module and  show what each check represents as a %  then have a text box with the codes of the  namesof the check mark with the sum code to get the percentage?

Something like this:

induction =10%
Defuel= 20%

(this in a text box) =DSumt("*","tblMODHistory","['Induction','Defuel')")
bingo.accdb
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros