Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating Current totals in Form (Access 2003)

    I have a form with Check boxes and Combos. I want some fields in a Form that counts the responses and displays them in current status when the form is accessed:

    1. Combo Box : Status: (copntains 3 variables): so I need the form to display how many records in the current Dataset that the form is accessing, are "Surplus" "In Use" or "Missing"
    So I expect a field to display: number of Surplus : ##


    2. Yes-No Field: I need to know how many Items are Yes....
    So I expect a field to display: number of Computers recovered: ##

    I can reuse the codes for any fields...
    Thanks

    Thanks

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

    Re: Creating Current totals in Form (Access 2003)

    1) <code>=Abs(Sum([Status]="In Use"))</code>

    2) <code>=Abs(Sum([NameOfYesNoField]))</code>

    PS was the reply to <post:=715,562>post 715,562</post:> helpful? You didn't post a reaction.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating Current totals in Form (Access 2003)

    Thanks Hans... this worked great....

    nice to see the Totals on the form....

Posting Permissions

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