Multi-Tabled Report 1

[Aubs010]

I have been trying for a while now to create a report based on a couple of tables.

Table 1 is the "Header" for the report, which is the building details.

The other tables are:
Electrical
Mechanical


so, a report would look something like:

Building 1
Electrical Item 1
Electrical Item 2
Electrical Item 3
Mechanical Item 1
Mechanical Item 2
Mechanical Item 3

Building 2
Electrical Item 1
Mechanical Item 1
Mechanical Item 2
Mechanical Item 3

Building 3
Mechanical Item 1
Mechanical Item 2
Mechanical Item 3

For some reason, even if I group the items, I can't get it to show ANY data at all!!!

The tables are all linked by [Property_ID], which is an AutoNumber in the building table.

Each other table had [Property_ID] and it's own associated ID: [Electrical_ID] & [Mechanical_ID] which are AutoNumbers on their table.

Any help would be greatly appreciated.



Aubs

 

[dhookom]

You should base your report on only "Table 1". Create two subreports to display the Electrical and Mechanical records. This is exactly the same as using subforms on a main form.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Aubs010]

Thanks Duane, I have used your idea and it works fine now

for you, sir!

Aubs