Report Design for max attendance date

[ET Sherman]

There are several ways to accomplish this, I generally
prefer using queries and base the reports recordsource on
the final query.

1. Query1 - Create this query that contains the field that
identifies each employe "Employee_ID" and "Employee_Name"
from your table.

2. Query2 - Create this query to select the "Employee_ID"
and the "Last_Date_Attended" from your table.

3. Query3 - Create this query based on Query1 and Query2.
Join on the "Employee_ID" field and set the join property
to include all records from Query1 and only records from
Query2 where the join fields are equal.

4. Set Query3 as the recordsource for the report.

Hope this helped.

ET Sherman