counting how many company records

[hooty]

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.

[hooty]

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.

[trevorg]

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.

[e3digital]

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

[andygaunt]

Have you tried to create a summary field,

Count (Month)

[e3digital]

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...

[andygaunt]

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.

[e3digital]

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