Is it possible?

  • Thread starter Thread starter JA
  • Start date Start date
J

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
 
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.
 
Back
Top