6 Replies Latest reply on Dec 31, 2010 11:03 AM by sugarking

    One code many entries / would like to be able to count the number of entries and summarize it

    sugarking

      Title

      One code many entries / would like to be able to count the number of entries and summarize it

      Post

      hi,

      i am new to filemaker, i have some data like trucks plates and trips. One day a truck can do 1 trip, another day the same truck can do 2-3 or 5 trips. 

      My intention is to show that the truck was operating that day meaning it did 3 trips but appears just one time

      example

      date               truck plate            trips

      1/1/2009         AAAA                      3

      RIGHT NOW, I AM GETTING 

      date         TRUCK PLATE      TRIPS

      1/1/2009      AAAA                   1

      1/1/2009      AAAA                   1

      1/1/2009      AAAA                   1

      I just want a unique appearance of the truck so i can count the different number of plates and summarize the number of trips the truck made :

      FOR INSTANC

      TRUCK PLATE          TRIPS

      AAAA                          1

      BBB                            5

      CCC                           3

      Total trips all trucks = 9