AnsweredAssumed Answered

Newbie summary field question

Question asked by paynetc on Aug 3, 2009
Latest reply on Aug 4, 2009 by ninja

Title

Newbie summary field question

Post

I'm brand-spanking new to FileMaker, so I'm sure this question is probably ridiculously easy to answer.  But I just can't figure out how to do it.

 

I want a field that adds values of a field together when the date is equal across records, no matter what the sort order is.

 

I have a date field and the field I want to sum over dates.  When I create a summary field, it seems that the records must be sorted by date in order for the summary field to work the way I want.  That is, clicking Restart summary for each sorted group and choosing the date gets me what I want - but only when the records are sorted by date.  When the records are unsorted, the summary field does not provide the desired result.

 

 

 

Outcomes