I have a database with 1000 records. In field1 there may be one of 10 different ID numbers. I am looking for the easiest way to create 10 records in a new layout, each with two fields: the ID number and the number of records in the first layout with that ID number. I could use a summary but I need to export the data into an Excel spread sheet. I can see two ways of doing this:
1) do a find for each of the ID numbers in the 1000 record database, get the count, and stick it in the appropriate field
2) loop through the 1000 records adding to a counter depending on the ID number
Is there a better and quicker way to do this?
Add a summary field defined as Count of ID (or any other field that cannot be empty). Sort the records by ID, and export grouped by ID.