Combine tables

[abbers_01]

I am looking to combine a tables with multiple queries into one table.

I have I have a table that contains a field [LEM] which is common to all 4 queries.

The 4 queries each have 2 common fields and 3 different fields.
LEM_A
- LEM
- WO
- A1
- A2
- A3
LEM_B
- LEM
- WO
- B1
- B2
- B3
LEM_C
and so foreth

I want to combine these into one table with a format like this:
LEM | WO | A1 | A2 | A3 | B1 | B2 | B3 | ...

I've ran into issues because some tables don't have the same information in the WO field, it ends up return into no information.

Any help is greatly appreaciated, thanks.

 

[the_net_2.0]

you can do this through recordsets in vba. queries aren't going to be much help to you because the engine cannot transform tables like this.

the alternate option of course, is to export all 4 queries to excel and use the 'transform' utility under the paste special menu, then import the data back in.

 

[abbers_01]

Thanks for your reply, however in the end I just created a new table with the format I wanted and looped through the queries to populate the table. Not my ideal solution for this but it works.