I am fairly new to filemaker and I have what might be a newbie question. I have a couple of thousands of records in a transactions table. This transactions table has a field called "Units IN".Basically I would like to calculate the sum of the first 50 or 100 records for that field. I have achieved this using an executeSQL statement, but I would like to know if there is another way to perform this task. I was thinking of something along the lines of building a custom recursive function.
Thanks in advance