Date Last Attended
Posted: Thu Jul 11, 2019 7:12 pm
I have created a custom weekly absentee report for my Pastor. I would like to include the last date attended. I'm not sure how to create the query for that date. Can you help?
First off, getting the 'absentees' for a specific date is easy, what you want to do involves reading the database and finding the 'greatest date' for each attendee.smaybury wrote:I have created a custom weekly absentee report for my Pastor. I would like to include the last date attended. I'm not sure how to create the query for that date. Can you help?