Results 1 to 3 of 3
  1. #1
    carletonw
    Guest

    Check Box Controls

    Using Access 2K I want to use check boxes in a subform that tracks attendance Mon through Sun and then add up all the checks for the week. How does one have the check box write a value of "1" the the table instead of the "-1" value. I need to sum up totals by week on the form then later by months in a report. I know it's got to be really simple but it keeps comming up in projects I'm working on. Thanks in advance.

    Carleton

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Check Box Controls

    Hi Carleton,
    I'd suggest just using -sum([fieldname]) rather than bother converting the -1 to 1 in the table.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    carletonw
    Guest

    Re: Check Box Controls

    Hi Rory,

    Thanks your ideal worked perfectly of course for both the form and the reports. I also used the "Abs" function to add the controls for different days of the week. i.e. Abs([chkMon])+ Abs([chkTue])+ etc. Sometimes it's the seemingly simple things that stump us..

    Carleton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •