[Programmer-VB] Query in Access

[wedhi access]

 Tambah **
*Table3*
  kolom0
 kolom1
 kolom2
  1
 a
 23
 2
 a
 34
 3
 a
 76
 1
 b
 54
 2
 b
 12
 3
 b
 90


buat Query8 dgn SQL sbb:

TRANSFORM Sum(Table3.kolom2) AS SumOfkolom2
SELECT Table3.kolom0
FROM Table3
GROUP BY Table3.kolom0
PIVOT Table3.kolom1;

hasilnya sbb:

 *Query8*  kolom0 a b  1 23 54 2 34 12 3 76 90