Results 1 to 6 of 6

Thread: [RESOLVED] Record Count per group

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Posts
    129

    Resolved [RESOLVED] Record Count per group

    Hi, is it possible to count each item in each record. what i've done is it counts every item regardless of group, thus counting all records. Any help is appreciated.

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Record Count per group

    Add a Running Total field
    Evaluate For each record and
    Reset on change of group

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Record Count per group

    Or create a formula using the Count summary function.

    Count ({Orders.OrderID},{Customers.CustomerID})

    Or use the Insert->Summary menu item.

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Posts
    129

    Re: Record Count per group

    Thank you so much!

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Posts
    129

    Re: Record Count per group

    is there a way to place the count or record number beside each item per group?

  6. #6
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Record Count per group

    Add a Running Total field
    Evaluate For each record
    Place the Running Total field 'beside each item'
    Reset on change of group

Posting Permissions

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



Click Here to Expand Forum to Full Width