Hi guys,
I have a query running with the help of some helpful people on this forum, but it is not in the format my users want. Is it possible to change the layout to the way I have diagrammed?
yes, you want a CrossTab query.
use the query wizard and begin, select your existing query (top)
the wizard will ask you how to lay it out. (the bottom version)