gigifarrow
asked on
Make a Check equal a percentage
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" ,"['Induct ion','Defu el')")
bingo.accdb
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"
bingo.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is the excel spreadsheet that my boss want me to turn into ACCESS May this will help you understand a littltle better
ExcelHelp.xlsx
ExcelHelp.xlsx
When a checkbox is checked, it has a value of -1. That's why I used ABS (Absolute) in the formula, it changes the value to a positve number. There are 17 checkboxes which is why the sum of the boxes is divided by 17. If you want each box to have a different value, you can assign the value in that formula as follows:
Percentages: Format(Abs((([tblTempleFue lcellOnly] ![Inductio n] *10)+([tblTempleFuelcellOnly] ![Defuel]*20 + ........../100,"00.0%")
Just make sure the 17 values totals 100
Percentages: Format(Abs((([tblTempleFue
Just make sure the 17 values totals 100
ASKER
wow thanks You are very good! I wish i could get to your level I buy books but they only go so far and it seems they never have the answers im looking for I will try this And again thanks for your expert help!!!!
ASKER
I dont see percentages on the table is that unbound?
Books will get you just so far. I have learned a ton by just reading these posts. Work the problem, even if an answer was already accepted. Think of a "what if" problem and then work on it until you find a solution. Once you find a solution, see if you can find a different one. I'm glad I could help you out!
ASKER
Flyster if your still out there. I know the percentages is a unbound code but where is the formula. I looked on the form maybe on current nothing. I looked on the propery sheet and I dont see it. I feel really dumb but I cant find the code.
ASKER
But I do have a couple of questions
1.How do I give each field a percentage value?
2. How did the field Percentages get on the form and I dont see it on the table?
You see every time the user checks one of the fields like defuel that is equal to 20% and then they may check Induction that equal 10% so the Total percentage of all the fields so far is 30%..
all these fields eventially add up to 100% once they have checked them all.
so where would I put this code would to put the value of each fields percentage?
How do I disquinquish which defuel i am talking about should i do it by production number?
or should I just do a drop down with the percetage value and then add them together
Which I did try but when i put .10 or .30 it defaults to zero on a lookup field