Report using Multiple Queries

Question

I have values shown in the figure below from the following 3 queries:

1. State – values in column E for all states and additional values in column F for some states.
2. Company – values in either column G or H for all companies.
3. Subsidiary – values in both columns I and J for all subsidiaries

Can anyone provide some assistance in how I could display the values of the 3 queries in a report as shown below. I would like the values shown exactly like indicated.  

Thank you

Answer 1

Can anyone provide some assistance in how I could display the values of the 3 queries in a report as shown below. I would like the values shown exactly like indicated.  

Hi William,

In the systematic that I use to make my reports, it would be peanuts. My reports are generated directly in RTF, readable and printable in many text-editing applications.

You can mimic this approach with a (non-keyed) table with the columns as in your example.

Next you make a procedure to fill this table with 4 nested loops for Region, State, Company and Subsidiary.

After filling this table, row by row, with the needed data in the right field, you can use this table as the basis for your report.

Imb.

Answer 2

Can you provide the SQL for the 3 queries and the structure of your tables. You could build the report using grouping and using the Hide Duplicates or using subreports. But we need to understand the structure to be more specific.

Answer 3

Scott

I realize it is difficult to provide constructive input/solutions without knowing the items you mentioned. What I had shown was a made up example to represent an actual problem. I think, as you mentioned, the key is to use grouping or subreports. This would be to construct a report based on multiple queries.

I could send the infomation you requested but I thought first it might be earsier for you to refer me to an example of a report using groupings or multiple queries. I have not done this previously so anything would be educational.

Thank you.

Answer 4

Grouping is easy. The Report wizard prompts you to select one or more grouping levels. SubReports work the same way subforms. Then link to a parent record.

Answer 5

Scott

I looked that over and have some idea on the grouping. That was helpful.

Thank you