I have a Filemaker 14 database of cash donors to my nonprofit. I need to export a number of its fields into an Excel file. The database is comprised of two related files: Donors and Donations. I am exporting from the Donations file for purposes of showing an aggregate total of lifetime giving for each donor. I have figured out how to do this part of it.
When I export the "Date of Donation" and "Amount" fields I get the oldest donation. What I need to do is export the most recent donation of the donor. Any ideas on how to do this?
Also, it would be great to export the largest lifetime donation of the donor as well. Any ideas on how to do this?
Thanks in advance for any suggestions!