It seems to me that you could probably use a subquery to get the last date of service. It's a bit more complicated with separate fields for the date parts. You might even have to use nested subqueries. Get the largest service year, use that as a key and get the largest month for records in that service year and then get the largetst service day in that service year/month and then use that to select records from the table.