Ahh...yes...You never said you needed other matching fields from that same record. Indeed, what you have done is basically the right way to do it. Kudos for recognizing the need to join MAXSGRP back to F_SGRP to get the right data. I take back what I said about needing to learn more SQL <grin/>. Many (most) Access users wouldn't have gotten that right.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.