How to group multiple criteria?

[schulzy175]

I am needing to show all statistics of each category grouped to each location. The example I have provided shows 3 services per location for the month. I am needing it to show all 3 services for each location instead of 1 service for each group for each location, but I cannot find any solutions online.

This is how it looks current when I run the report:




This is how I am needing it to look:

[JoeM]

On your report, what field have you grouped on?
And in which report sections have you placed the Location and Wtype fields?

[schulzy175]

On your report, what field have you grouped on?
And in which report sections have you placed the Location and Wtype fields?

I have location name grouped as well as the Wtype, but the Wtype doesn't seem to be affected. Everything is in the "detail" section.

[JoeM]

Get rid of the Wtype grouping.

How is the data structured in the Table/Query that is the record source for this Report?
Can you post a small sample?

[schulzy175]

I have no record source for this report. I needed multiple sources to accomplish my goal for the report, but instead, I've appended all my queries to tables so I can adjust the data layout more easily.

[JoeM]

I don't follow.
A Report MUST have a Record Source attached to it - or else it has no data to report on!
If you go to Design View of your Report, go to Properties (make sure you have "Report" selected), and go to the Data tab, what does it say on the Record Source line?

Your best best may be to upload the database here, if possible, so we can look at it ourselves and analyze it. If you do that, just be sure to remove any private/sensitive data first.

[schulzy175]

I don't follow.
A Report MUST have a Record Source attached to it - or else it has no data to report on!
If you go to Design View of your Report, go to Properties (make sure you have "Report" selected), and go to the Data tab, what does it say on the Record Source line?

Your best best may be to upload the database here, if possible, so we can look at it ourselves and analyze it. If you do that, just be sure to remove any private/sensitive data first.

I'd love to upload my DB because I know it can be more help, but the entire DB is too sensitive. The actual DB linked to MS Access is 4.5gb.
My "record source" is blank at the moment because I left it like that. At the moment, I can use any field from any table, but If I want to use fields from queries, I have to ink it via record source. If I do this, I cannot pull information from any other queries except for the one query linked as my record source. That's why I chose to use tables. EDIT: Ill post some pictures.

[schulzy175]

I got it! I had to take off some of the textboxes and add some more sorts. Here is what I found.



As for my table setup and record source: