Hello all,
I have 3 tables with 1 field in each. The third table has half a
million rows in it so I can do this with excel. What I want to do is
create an array that I can export to Excel. The data is as follows:
Table 1: C1, C2
Table 2: M1, M2, M3
Table 3: L1, L2, L3, L4, L5, L6
The problem is that I want each value for Table 1 on the side and each
value for Table 2 on the top as headings with Table 3 filling in the
data. There is a relationship that needs to be held. For this data,
the results I want would look like:
M1 M2 M3
C1 L1 L2 L3
C2 L4 L5 L6
I can't seem to figure this out in Access vba. Any pointers or help is
appreciated.