I have 1100 records in a found set. 12 records are for 1 customer 2 records are for another customer etc.

My question how can I get an individual count of each customer in the found set.

It depends on what purpose you need these counts for. Usually it is sufficient to define a summary field that counts the records and place it in a sub-summary by customer part. When you sort the records by customer, you will see the individual count of each customer in their sub-summary.

 

Thanks for the response. The problem I'am having is it gives a total of all records in the records for that customer, not just the found set.

A summary field counts only the found set - and when placed in a sub-summary part, it counts the sorted group (a subset of the found set).

 

Edited November 20, 20205 yr by comment

I have the sub-summary sorting by customer name but I still get all the record count for al that customers records.

Out of 1100 records found and sorted I'am just trying to get the number of pay dates for each.

 

 

4 hours ago, mj3411 said:

I still get all the record count for al that customers records.

If you are not getting the expected result, then you are not doing what I suggested. Since I cannot see what you are doing, I don't know how to fix it.

The attached file demonstrates clearly that summary fields summarize each sorted group of the current found set.

 

SummaryOfGroup.fmp12

Edited November 20, 20205 yr by comment

Thank you for your reply. I will have to try and adapt your demo to my file.

Thanks again I got it. I have been off & on FileMaker for 10 years, I worked with it for 20 years so you would think I wouldn't be so rusty.

Again thanks. (I couldn't see the forest for the trees)