# Assigning a total dollar value to check boxes, when each of 4 check boxes is worth \$25.00

1. Novice
Windows 10 Access 2013 64bit
Join Date
Oct 2020
Posts
1

## Assigning a total dollar value to check boxes, when each of 4 check boxes is worth \$25.00

On the attached you will notice the line "Total Yearly Fees Owed". Then next to it are 4 check boxes with 9th, 10th, 11th, 12th next to it. Each of these check boxes are worth \$25.00. So each time one is checked it would add \$25.00 for up to a total of \$100.00 over the 4 years in the "Total Yearly Fees Owed" box, or subtract \$25.00 for each year that is unchecked/paid. I have gotten all my formulas to add up but I cannot get this to work. I would greatly appreciate some assistance. I have attached my sample page. Thanks!

2. For the TotalFeesOwed textbox control source enter =IIF([9th]=True,25,0)+IIF([10th]=True,25,0)+IIF([11th]=True,25,0)+IIF([12th]=True,25,0) or do that in the query that acts as the record source for the form or report. Note the that for the control source you need to use the checkboxes control names, for the query the corresponding field names.

Cheers,

3. Originally Posted by jmare
On the attached you will notice the line "Total Yearly Fees Owed". Then next to it are 4 check boxes with 9th, 10th, 11th, 12th next to it. Each of these check boxes are worth \$25.00. So each time one is checked it would add \$25.00 for up to a total of \$100.00 over the 4 years in the "Total Yearly Fees Owed" box, or subtract \$25.00 for each year that is unchecked/paid. I have gotten all my formulas to add up but I cannot get this to work. I would greatly appreciate some assistance. I have attached my sample page. Thanks!
I think you would be better to post a copy of the db. I'm guessing that it's not normalised and that you have bound the "Total Yearly Fees Owed" to a field in a table which, IMHO, it shouldn't be because it si a calculation.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Other Forums: Microsoft Office Forums