If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create Report linked to multiple tables
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! |
#2
|
|||
|
|||
Create Report linked to multiple tables
Leslie wrote:
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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|