Unsophisticated user needs help finding most recent date
I hope someone will take pity on me. I have been using Filemaker for a long time, but as a user, not a database developer. So I am familiar with the basics and know how to create simple fields. But something that I thought would be simple has me stumped:
I am using Filemaker Pro 9 and have a database that tracks, among other things, attendance at group meetings. This particular issue involves 2 tables, the Client Table and the Attendance Date Table. They are linked through a Client ID #. We have people who have as few as 1 visit and others with almost 200 visits.
All I want to do is to be able to pull up a report that shows me which people have not attended in over a year. So I am trying to create a field that will show me the most recent visit for each client. I have tried using both the Min function and the Max function and also Last, but they all bring up the same date for each client, which is the first attendance date for that client.
Is this a sorting issue, or is there something else that I'm missing?
I would appreciate any help at all. Thank you.