why cant I do this simple Calculation

[jeff-M]

Heres my issue.. I have created a database to enter competitors in a car show what I need to do is take the points for each competitor and add ( SUM) them so I can award the Club Participation award for the highest amount of point..

So if club A has 3 cars with 100, 200, & 300 Points I want a field to total the 600 Points in a field and if club b has 100, 100 & 100 Points the field will reflect that that club has 300 Points..

Does Filemaker have the capability to sum the total from a particular field from multiple records? If it does. Please respond with a simple explanation of the calculations...

Thanks and Regards! :)

[LaRetta]

Welcome!

In your table, create a new field called sTotalPoints. It would type Summary and 'total of points.'

Now create another table called Clubs. In it, each record would be Club A, Club B etc. Join this table to your first table on Club using =. Create a list in your Clubs table with only the Club Name and also copy the new summary field from your first table and place it next to the club name.

UPDATE: I suggest another table because I believe you will need one in more ways. But you can accomplish what you wish with only your existing table as well:

In your field definitions, still create your summary field. Then create another occurrence of your table (in graph select it and click the ++ at the bottom). Call it Club Points. Join to your original table occurrence on Club. On your layouts, place a copy of your summary field from your Club Points table.

Edited May 13, 2010 by Guest
Added update