Portal records and Reports
My database is for a non-profit. I have a portal that stores donations. When there are many (some donors have up to 30 donations from different years) I don't know how to only show the most recent donation in a report.
For example: I created a report that pulls the fields from my donations portal (date of donation, amt, reason-etc) and fields from the main table (name,contact info, etc). The issue is that this report is to show only the most recent donation and even when I sort portal records or do a find within the report - I can only see the oldest donation.
No idea if this makes sense.Any tips?