Newbie summary field question
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.