How to count how many times an email address appears in a table
I'm making a solution that will tell me how many of my customers have participated in various promotions that we've had. I have a table that has a record for each time a customer has participated in a promotion. I'm trying to figure out a way to make a report that lists the customers that have participated in the most promotions. I need to figure out how to make a calculation that counts the number of times a particular email address appears in that table.
I'm a FileMaker newbie. I've been searching the internet for days and reading all about calculations, but I haven't had any luck figuring it out. I'd really appreciate it if anybody has any ideas how I should go about this, or if anybody could point me in the right direction. Thanks!