Too many Queries?

[Hunter J.]

Is it advisable to run 39 queries and then bring them together in another query so that I can include them on one report? This question arises from another topic that I have in the general topics area that I should have started in here. Sorry about that.

Thanks in Advance,
Hunter J.
Novice at Access

 

[The_Doc_Man]

What is the last query? A big 39-way UNION query?

Normally, I would say 39 queries is excessive, but everybody's problems are different. I guess I can imagine cases where 39 queries represents the exact number you need.

So there is no clear-cut "just right/too few/too many" answer. It just flat out depends on what you are doing.