The solutions suggested can't really be much better than the information provided, which unfortunately, is not very much. Why are there multiple queries on the same table or sets of joined tables? Is it because you're returning the same fields but based on different parameters (such as dates)? Or are different fields being returned, and regardless of which it is, you want to message box the query results? Maybe we ought to be telling you to use a form and pass the parameter(s), thereby only having one query (or at least fewer than you currently have) against that table or set of tables. Or maybe you might benefit from a function that could build the message regardless of which query you use.
It does seem strange that you want to present query results in message boxes though...
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.