What I proposed was a series of three queries. First Query (gets latest appointment per client) saved as FirstApt -- Based on the table Appointment -- Add ClientID and AppointDate as the fields -- Select View: Totals from the menu -- Change Group By to MAX under AppointDate -- Add an alias for the date by typing LatestAppointment: in front of the field name Second query (gets the next