Is it possible?

[JA]

Is it possible to transpose Table 1 to Table 2?

TABLE 1
Start_Date Course Duration
08/05/04 A 2
09/05/04 B 1
09/05/04 C 3
08/05/04 D 3
10/05/04 E 2

TABLE 2
08/05/04 09/05/04 10/05/04 11/05/04
A A
B
C C C
D D D
E E

 

[Alex Dybenko]

not sure this is possible with a single query, but you can open recordset on
table1, loop through it and add/edit corresponding rows in table2.