Thanks for your reply - I used what you suggested, then found the other fields I was looking for (especially needed lastS) based off this sub query. Looks like I...

My description was not clear: "I need to find the distinct records having both the minimum & maximum date (lastD) for each MName" - Apologies again.

I need to find the...

Apologies for not posting more thoroughly! The db is third party and I'm not looking at it, but I believe this is very close. The bolded/colored records are an example...

Thank you so much for your reply. I can't test your query now, but I don't think it will work because lastD is not unique? idD is not unique either....