combining data from 2 table into a new one

**st0kvis** · 08-09-2011, 01:09 PM

i have 2 tables

table1 with columns number,category,answer
table2 wtih columns number, category, answer

table 1 looks something like this:

number category answer
1 training yes
3 coaching no

table 2 like this:

Number category answer
2 walking yes

I want to make a new table that consists out of the category answer only and should look something like this

Column heaaders should be training, coaching, walking

example,

coaching training walking
yes no yes

Can someone help me with a Query or an idea?

**davegugg** · 08-09-2011, 01:58 PM

Personally, I think it'd be easiest to export the two tables to excel, set them up how you want the new table to be in excel, which should be quite easy, and then import back into Access as a new table.

You could set up some code in Access to create the new table and then fill it with info from the two tables, but it would be much more complicated.