Data from number of queries/tables in a single report

[malaydash]

Hi

I have a database in which I have number of queries/tables. Some of these queries/tables are related to each other & some of them are totally independent of each other. I am able to make individual report for every queries/tables. What I want is to combine the individual report into one single report. In this way I can have all the information in one place & I don't have to open individual reports. The idea is to get all the information (whether related or not) in one place & also to save paper in printing.

To make it more clear lets say I have a database in respect of a general industrial set-up having the following queries/tables
1. Raw_material
2. Machines
3. Manpower
4. Capital
5. Production
6. Order
7. Sales
8. Customer

Now, although in an industrial set-up all the above areas are very closely related to each other but say in my database Item no- 5, 6, 7 & 8 are related whereas Item no-1, 2, 3 & 4 are completely independent of other. And now lets say I have very few data in each of the above Table/queries which can fit into one single page and lets say I am the chairman of the company & I want to view the report in one single page so that I have an holistic view of what is going on in my company in each of the above mentioned departments. This will be very helpful to make decision in a quick & just way. In other words I want to fit all the eight reports into one single place. This is like pasting of eight individual reports into one page just like a jigsaw puzzle.

Now the question is whether it is possible to build such a report or Access allows only data from related queries/tables to be put in a single report? And if it is possible how to do the same?

All your help will be kindly appreciated.

Thanks & Regards

Malay Dash

 

[bob fitz]

In other words I want to fit all the eight reports into one single place

Create an unbound report as the main report and put each of the eight reports in the main report as sub reports.

 

[malaydash]

Dear Bob Fitz

The world really seems to be a better place to live when people like you are around. I was astonished by the prompt response given by you. In the past also I have raised a few questions in this forum & every time a noble soul like you appeared to help. Hats up to people like you & thanks for the support you people are giving to the newbie like me. We may never meet you in person but you will always remain in the heart of millions of new learner like me.

Anyway I make a trial using your suggestion & it worked as desired. I have not yet finalized the report, but I think I can do it now. However I will be needing your help if I get stuck in something while doing the same.

I don't know if I am asking too much but can I make the final report without preparing the intermediate reports first? In other words can I build the eight individual reports directly in the main report? Please answer if there is a solution for that.

Anyway thanks for everything & lots of compliments for the work you are doing.

Regards

Malay Dash

 

[bob fitz]

Hi Malay,

Thank you for such kind words on the efforts of myself and others here, in our attempts to help you. They are very much appreciated.

...can I build the eight individual reports directly in the main report? Please answer if there is a solution for that.
...

I'm not really sure what you mean by "building directly in the main report" but it is possible to create a subreport while the main report is in design view.

 

[cb@chrisb.eu]

Hi. I've done as you suggested above, and have created a couple of reports consisting of sub-reports, each using queries. For a simple digest of the previous month, this works fine. However, I now need to offer a choice of month covered, which involves parameter dialog boxes. But how do I ask only one set of (identical) parameters for 12 queries, which at the moment want to ask the (month/year) question 12 times for one report?

 

[bob fitz]

Perhaps you could create a form from which the main report is opened. The form could have a couple of text boxes for the date parameters and each of the reports could reference these text boxes for the dates.

 

[cb@chrisb.eu]

Hi Bob. Thanks for this. The sub-forms happily get their date from the date on the form. My problem is this date. If I get this date from a query/table, it won't accept a date unless it already exists on the table.
If I set this up as a straight text box =Format([MonthYear],"mmm yyyy"), I get #Type! in all the date boxes. I'm sure I'm doing something wrong, but what is it?

 

[bob fitz]

Can you post a copy of your DB in Access2003 mdb format, with just a few dummy records.