Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report sum (2000)

    I have a report that has a field called Client Type. In this field the data is either Assoc or Client. I would like to total the "number of members" field according to the client type field. I only want to total the ones that have a client type of "Assoc". I have a total for the entire "number of members" field but I need a total number of members for the Assoc client type. How can I do this in the report footer? Thanks for any help you can provide.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report sum (2000)

    You could use the DSum function. Set the control source of the textbox to :
    <pre>=Dsum("Number Of Member Field","YourTableName","[Client Type] = 'Assoc'")</pre>

    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report sum (2000)

    It gives me an error. Maybe I am not entering it right. Should I enter it exactly the way you have it or should I omit quotes. I am entering it like this:
    =Dsum("Client Members","LRqry_AssocGroups_07_11_Spec_Accts","[ClType] = 'Assoc'")
    The report has a query behind it so I substituted the query for where you indicated "YourTableName".

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

    Re: Report sum (2000)

    Try DCount instead of DSum:

    <code>=DCount("Client Members","LRqry_AssocGroups_07_11_Spec_Accts","[ClType] = 'Assoc'")</code>

    DSum adds values together, DCount counts the number of records that meet the criteria.

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report sum (2000)

    It was not clear for me if it was the sum of a numeric field (client members) or a count of the records.
    Francois

Posting Permissions

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