I think this must be something simple but I'm not figuring it out. If I have a company name field, that obviously will have different companies in it, and I want a count of how many records belong to each company what do I do? Not simply a total either. There's a company number 001, 002, 003 and then the next number in the sequence would be 001-1, 001-2 etc as new records from each company are created.

Summary fields may be the answer but I need the number to display and update as new records are inputed. It would need to be accurate in the browser view. It would be displayed on each record as a part of item number. Once displayed it shouldn't change.

Working on it some more and I'm able to do a find and copy from the company summary field into the number field.

But...The find won't refresh. I don't have any restores on or anything but it keeps doing the same company find over and over again.

Tried figuring out a getsummary calculation but, well, not a number appeared there.

You can use a relation to do this.

If you want to count the number of records for a particular client, setup a self-relation (if this is all within one file).

If you have something like Company_ID, create the relation so Company_ID = CompanyID

Then create a new calculation field that is:

Count (Self-Relation_Name::CompanyID)

You can use the same method for line items through a relationship.

This is exactly what I need to do also, but how do you populate CompanyID? (My situation is that I need to count how many records exist for each month. I have a date field from which I've calculated a month field)

Thanks for your help.

susan

Have you tried to create a summary field,

Count (Month)

Yes, but I need a count of each month simultaneously. I can get it for a month at a time, but I need to be able to see how many records in January and February at the same time...

You want to see January AND February at the same time?

Do you mean count them together, or view them together.

Is this for a report?

If a report, consider a sub summary part.

I mean view them together. I need to be able to use the number of records in each month in a calculation. It's for a type of grade book...I need to divide the points attained by the number of attempts (students get one attempt each day). I need to print a report each month but also be able to look back to previous months to see any trends....

thanks for all your help.

Susan