Table2 | ||
Nama | Value | Tanggal |
a | 10 | 01/11/2010 |
a | 20 | 02/11/2010 |
a | 30 | 03/11/2010 |
a | 40 | 04/11/2010 |
b | 7 | 01/11/2010 |
b | 8 | 02/11/2010 |
b | 9 | 03/11/2010 |
b | 5 | 04/11/2010 |
c | 22 | 01/11/2010 |
c | 31 | 02/11/2010 |
c | 42 | 03/11/2010 |
c | 41 | 04/11/2010 |
Akan lebih mudah menjadikan data table2 menjadi Crosstab query dari pada sebaliknya. Table2 saya tambahkan tanggal , dan hasil crosstab query seperti di bawah ini:
Query design Crosstab sbb atau :
TRANSFORM Sum(Table2.Value) AS SumOfValue
SELECT Table2.Nama
FROM Table2
GROUP BY Table2.Nama
PIVOT Table2.Tanggal;
Best Regards,
AccessWizards
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of Anton Gundul
Sent: 29 Nopember 2010 12:01
To: belajaraccess
Subject: [belajar-access] tansform/crosstab/pivot??
Dear para suhu dan teman-teman sekalian |
__._,_.___
SPAM IS PROHIBITED
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
No comments:
Post a Comment