Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adding check boxes (2003)

    OK...It is Wednesday and I give up!!!

    I have a form with multiple check boxes. I want to total the number of checks when there is a change in Physician. It can not be that hard but I am not getting my answers on my report.

    I created an unbound control =iif(noh&p)=-1,1,0)....I get a 1 - this is good. I named this box toth&p.
    then I created another unbound on the physician footer =toth&p with running sum = yes. I get a 1...not good.

    So what is up??? My brain is fried and it is only Wednesday...

    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: adding check boxes (2003)

    Set the control source of the text box in the footer to =Abs(Sum([noh&p]))

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: adding check boxes (2003)

    It is REALLY not a good idea to use the "&" symbol in control and field names. Unless you ALWAYS encompass the names in brackets [ ], Access may get confused and think you are trying to concatenate fields into a string.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: adding check boxes (2003)

    I fully agree with that!

    In general, the names of database objects, fields and controls should NOT contain spaces and unusual symbols such as punctuation. It's best to stick to letters, digits and underscores.

Posting Permissions

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