Yes, but it only summarizes the found set in the same TABLE.
So if I have Donors --< Donations, a summary field in the donations table is required to summarize a found set of donation records.
I have created the Summary Field (Amount) in the Donations Table, then sorted the donations by donor ID #, and the result is still the TOTAL $ donated by the donor, as opposed to the total $ in the found set, by donor.
My brain hurts.
Thanks for any suggestions.
Exactly as Mike says. Statistics fields count those records who is found. Se my example. I Am little bit confused when U say Summary field! Is this a Static's field who sum? or is it a Counting field with Sum() function?
I´ve done a Example with three different IDs´ A,B and C. There is a Static's Field who just counts all shown values in those records I chosen.
Just press any ID.
Sorry if I come in as a third part. :-)
SumExample.fmp12.zip 67.6 K
Thanks for your help, I think I have found a way ahead even though I still can't figure out why it's working on some layouts and not others of the same table . . .