Hi,
I'm strugling with the following:
I have an existing table with columns ResID, StID, WCID, Res, Com. StID and WCID are linked to other tables.
The StID, WCID and Res columns look like this:
StID WCID Res
1 1 12
1 2 12
1 3 14
1 4 15
2 1 10
2 2 9
2 3 7
2 4 14
What I would like to do now, is have another table, based on the values in StID, WCID and Res in the existing table.
The table should have the columns StID and 1, 2, 3 and 4, so that the new table looks like this:
StID 1 2 3 4
1 12 12 14 15
2 10 9 7 14
I presume I should first make the table, and then use an append query. However, I just don't get there. Anyone any suggestions? Thanks in advance!
I'm strugling with the following:
I have an existing table with columns ResID, StID, WCID, Res, Com. StID and WCID are linked to other tables.
The StID, WCID and Res columns look like this:
StID WCID Res
1 1 12
1 2 12
1 3 14
1 4 15
2 1 10
2 2 9
2 3 7
2 4 14
What I would like to do now, is have another table, based on the values in StID, WCID and Res in the existing table.
The table should have the columns StID and 1, 2, 3 and 4, so that the new table looks like this:
StID 1 2 3 4
1 12 12 14 15
2 10 9 7 14
I presume I should first make the table, and then use an append query. However, I just don't get there. Anyone any suggestions? Thanks in advance!
