There may be other ways to do it, but not, I think, simply by using queries. I've been doing this a long time, but I still don't know everything ... by a long shot. This is the way I would do it.
Of course, if you want this to appear in a form, you might write some VBA code to process the...