Creating an Access Report from multiple queries
Posted on 2005-04-04
I asked this question previously and the solutions did not help. I really need an answer on this. I have a database with many queries that provide counts on responses. I need to put the results of all the queries into one report. For example:
query1 - count of smokers 20
query2 - count of depression 13
query3 - count of high stress level 24
How can I have the results appear in one report? I tried subreports, but each subreport takes up too much room, when it needs to be just one line of data.