Create Report linked to multiple tables

[Guest]

The following is an example of the multiple tables I have with the same field
types. (I needed to separate them for switchboard command purposes desired by
customer)

Table 1 - Carrier, Rate Plans, Price
Table 2 - Carrier, Rate Plans, Price
Table 3 - Carrier, Rate Plans, Price

This list goes on to about 10 tables with the same fields. I am needing a
report that will spit these values out like they were all in one table.

Table1_Rate Plan, Table1_Price
Table2_Rate Plan, Table2_Price
Table3_Rate Plan, Table3_Price

And I would like to group them by carrier. What would be the most efficient
way to accomplish this without creating one big table or multiple queries?

Thanks!

 

[Marshall Barton]

The following is an example of the multiple tables I have with the same field
types. (I needed to separate them for switchboard command purposes desired by
customer)

Table 1 - Carrier, Rate Plans, Price
Table 2 - Carrier, Rate Plans, Price
Table 3 - Carrier, Rate Plans, Price

This list goes on to about 10 tables with the same fields. I am needing a
report that will spit these values out like they were all in one table.

Table1_Rate Plan, Table1_Price
Table2_Rate Plan, Table2_Price
Table3_Rate Plan, Table3_Price

And I would like to group them by carrier. What would be the most efficient
way to accomplish this without creating one big table or multiple queries?

You ought not to use multiple tables for the same kind of
data.

Until you put things back the way they should be and create
queries for the switchboard commands, use a UNION ALL query
to put the tables together.