Displaying All Tables in Report

[vCallNSPF]

Im fairly new to access and I havn't used in about 6 months so I can't remember how to import ALL tables into a report.

Background information:
Im working for a company that provides equipment for aged care, I have tables for each kind of equipment. In the end I need one giant report showing all the equipment for the facility. So I need each table imported.

Thanks in advance for any help.

[genesis]

one table for each kind of equipment? why do you need to create one table of each kind of equipment?

[vCallNSPF]

one table for each kind of equipment? why do you need to create one table of each kind of equipment?

Sorry for the late reply,

Each different kind of equipment needs different fields for different attributes of each kind of equipment.

Eg. A system controller is a kind of equipment and has fields for master type, software version, printer link etc. A repeater is another kind of equipment which has fields for timing, type, battery, power packs etc.

so they cant be in the same table because they need different fields

[accessgenie]

If the tables aren't linked to each other by a key field (i.e., ID number of customer who ordered, sales person who purchased, etc.) then just open an unbound report and add subreports for each table to it, one after the other. (Otherwise, the primary table with the common linking field should be the source for the main report.)

[vCallNSPF]

If the tables aren't linked to each other by a key field (i.e., ID number of customer who ordered, sales person who purchased, etc.) then just open an unbound report and add subreports for each table to it, one after the other. (Otherwise, the primary table with the common linking field should be the source for the main report.)

Thanks heaps, I knew it was something like this but I couldnt remember.