Unrelated tables to print on one report

[northernbeaver]

I have three different Kinds of Purchase Orders. each kind is in its own seperate table. very close to each others structure but no relationship between the three. how do I get the three of them to print on one report? any ideas? the purpose of the report is to show all outstanding purchase orders.

 

[jmeadows7]

Hmmm... several ways to go about it..
1. You could try three sub reports embedded in a report - one for each of your types of POs.

2. If the information is actually pretty similar, you could append all of the data to a single table in your database that includes the PO type and run the report off of this data.

 

[dhookom]

Either combine the tables into a union query or use three separate subreports on one main report.

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

 

[northernbeaver]

Thanks all, I think I'll Create a temp table and dump the info to it. thanks for the idea!