how to merge two or more tables horizontally with vba?

[registoni]

I have a vba code that creates several tables [temp_financials2006, tem_financials2007,...,temp_financials2012], all with two fields : the 1st one is common for all tables (entity_ID) but second tables is different (Amount as per different year). I need to merge all tables into one, so that the1st column would be the Entity_ID and several other columns - one for amount per each year.

Union query does only vertically merge, but I need horizontal merge (I need denormalize the table on purpose).

[JoeM]

I think what you are looking for is a Cross-Tab Query: http://office.microsoft.com/en-us/ac...010229577.aspx

[registoni]

I think what you are looking for is a Cross-Tab Query: http://office.microsoft.com/en-us/ac...010229577.aspx

simple cross-tab query worked super! How could I forgot about this? Thanks alot.