AnsweredAssumed Answered

Counting records

Question asked by rsagall_1 on Mar 19, 2010
Latest reply on Mar 19, 2010 by comment_1


Counting records


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?