I need to create an output table/report for a large data set based on input from 8 other tables

[Priestm]

I need to create an output table/report for a large data set based on input from 8 other tables.


Examples of the 8 input tables (only 3 for the example):-

Table 1

Dates	000001 CH Equity	000002 CH Equity	000063 CH Equity	000069 CH Equity
01/01/2018	0.001242430	0.014554301	0.005486683	0.017944970
02/01/2018	0.001242430	0.014554301	0.005486683	0.017944970

Table 2

Dates	000001 CH Equity	000002 CH Equity	000063 CH Equity	000069 CH Equity
01/01/2018	1.008085478	1.145328606	1.582865819	1.080813958
02/01/2018	1.010199752	1.157845304	1.568495326	1.096245981

Table 3

Dates	000001 CH Equity	000002 CH Equity	000063 CH Equity	000069 CH Equity
01/01/2018	0.150000000	2.150000000	1.000000000	0.570000000
02/01/2018	0.150000000	2.150000000	1.000000000	0.570000000

Output result

Company ID	Date	Table 1	Table 2	Table 3
000001 CH Equity	01/01/2018	0.001242430	1.008085478	0.150000000
000001 CH Equity	02/01/2018	0.001242430	1.010199752	0.150000000

Is this possible? There is a large amount of data on the 8 input tables (1305 rows for 230 companies)

Any help would be greatly appreciated

[Welshgasman]

Union all the tables into one query with an extra field to identify table, then use a crosstab query on that?

https://www.google.com/search?q=cros...hrome&ie=UTF-8

[Priestm]

Thanks, I'll give it a go