I have about 5,000 records.  Those records are for about 300 different customers.  Some have 1 record, some have 50.  I'd like a way to see a list of customers, and how many records they have in their name.  I would assume that would be fairly easy, but i'm not 100% sure how to do it.

 

Example

ABC Company (50 records)

Bob Company (12 records)

etc.

 

Any advice?  Thanks!

You can produce a summary report of your table. Sort the records by customer and show them in a layout that contains a sub-summary (by customer) part and no body part. Place a summary field defined as Count of Customer (or of any other field that cannot be empty) in the sub-summary part, along with the Customer field.

 

You could also build a table of Customers (where each customer would have a unique record), and show the counts there via a relationship.

 

Finally, there's the option of using ExecuteSQL

You can produce a summary report of your table. Sort the records by customer and show them in a layout that contains a sub-summary (by customer) part and no body part. Place a summary field defined as Count of Customer (or of any other field that cannot be empty) in the sub-summary part, along with the Customer field.

 

You could also build a table of Customers (where each customer would have a unique record), and show the counts there via a relationship.

 

Finally, there's the option of using ExecuteSQL

 

THANK YOU