Help: Multiple Queries for one report

[AnnaZ]

Hello,

I have 5 separate queries that contain similar info for 5 separate categories. I need to create one report that contains data from all those queries. Is there a way I could do that?
I would need the data to go across, from left to right, and then have totals calculated at the end last columns.
I've been struggling with this for a while now, any help or ideas would be greatly appreciated.
Thanks in advance!

 

[Cosmos75]

Hello,

I have 5 separate queries that contain similar info for 5 separate categories. I need to create one report that contains data from all those queries. Is there a way I could do that?
I would need the data to go across, from left to right, and then have totals calculated at the end last columns.
I've been struggling with this for a while now, any help or ideas would be greatly appreciated.
Thanks in advance!

Are your queries exactly the same with the exception that they are each filtered for a particular field named "category"? If so, you can just use one query and group them when you create the report.

If not, you will need to create a report for each query. Then create one more report and add those 5 reports as sub-reports.

If you could post a zipped Access file with some dummy data, (just leave the tables & queries in, delete all forms and reports). I would be willing to take a look at it and help you out when I can find the time.

Hope this helps!

 

[AnnaZ]

Cosmos 75,

Thank you very much.

My queries are pretty much the same, but I don't think I can just group them all in one query, because I created them step by step, through other queries. I think I created 2 queries that give me the last one, and so forth for each one of the five final queries.

As for sub-reports, that might work. Say I created 5 separate reports, how would I add them as sub-reports into one big report?

I'm attaching my database with some dummy data. The 5 queries with word "AND" are the 5 queries that I'd like to display in one report. Thanks for offering to help. I really appreciate it. Let me know if you have any ideas/suggestions.
Thanks!!

 

[Cosmos75]

Take a look at the report - rptALL.

Is that somewhere along the lines of what you are looking for?

 

[AnnaZ]

Take a look at the report - rptALL.

Is that somewhere along the lines of what you are looking for?

Cosmos 75,

Thank you. What you created is similar to what we already have, but my boss wants me to create something different, something like the attached spreadsheet, but in Access.
If you look at the spreadsheet, it shows everybody's names and a lot of different totals and subtotals. any ideas?
Thanks!

 

[Cosmos75]

Cosmos 75,

Thank you. What you created is similar to what we already have, but my boss wants me to create something different, something like the attached spreadsheet, but in Access.
If you look at the spreadsheet, it shows everybody's names and a lot of different totals and subtotals. any ideas?
Thanks!

Does it have to look like that? Or is a different layout acceptable?

 

[AnnaZ]

I don't think it has to look exactly like that, as long as it accomplishes the same purpose and all the numbers and totals are sort of aligned and easy to read across. The way we have this report now is that it prints out on many pages and is hard to read, whereas with an Excel spreadsheet the same info can be captured on one page. Except that it has to be in Access.

Thanks.