AnsweredAssumed Answered

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

Question asked by sugarking on Dec 31, 2010
Latest reply on Dec 31, 2010 by 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

Outcomes