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","['Induction','Defuel')")

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((([tblTempleFuelcellOnly]![Induction] ![Defuel]

Just make sure the 17 values totals 100

Percentages: Format(Abs((([tblTempleFue

***10**)+([tblTempleFuelcellOnly]

***20**+ ..........

**/100**,"00.0%")

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