AnsweredAssumed Answered

Newbie Question about Groups and sums

Question asked by johnjohn on Feb 17, 2015
Latest reply on Feb 18, 2015 by philmodjunk

Title

Newbie Question about Groups and sums

Post

Hi to all,

I am total newbie on this so sorry for the stupid question.

 

In my struggle to understand filemaker i have the following scenario

I have a table with the following records and fields

............field1...........field2

rec1.....1/1/2014.........3

rec2.....1/1/2014........5

rec3....3/3/2014........12

I need to create another table that i keep the grouped sums of the above table and updated every time a new rec created.

like..

 

rec1.......1/1/2014.....8

rec2.......3/3/2014....12

similar the sql command select field1,sum(field2) from table GROUP BY field1

How can i do this?

Outcomes