Help and question about using Sum function
FMP 10 on Mac and PC
I have a Table that we use to keep track of hours worked and personal hours. This one table tracks six people. A new record is made every week for each person. So six new records are made each week. How can I keep a running total of the personal hours for each person, but limit what it totals to just this year, 2011? I really want to make sure it only totals each person's personal hours and not just sum all six people's personal hours. Does this make sense? Is this possible?