Results 1 to 3 of 3
  1. #1
    jmare is offline 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!
    Attached Files Attached Files

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    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,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by jmare View Post
    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.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-07-2020, 11:21 PM
  2. Replies: 5
    Last Post: 10-09-2017, 07:19 AM
  3. Check all check boxes on continuous form
    By NISMOJim in forum Forms
    Replies: 7
    Last Post: 06-14-2016, 02:14 AM
  4. Check box based on values of other check boxes?
    By Michael.Reynolds1775 in forum Forms
    Replies: 3
    Last Post: 03-25-2015, 12:58 AM
  5. Total of column with check boxes
    By turbosdad in forum Queries
    Replies: 4
    Last Post: 08-07-2010, 07:03 AM

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