1 Reply Latest reply on Mar 19, 2010 12:22 PM by comment_1

    Counting records

    rsagall_1

      Title

      Counting records

      Post

      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?

       

      Thanks,

       

      Rich