SELECT DATA_KELUARGA.NO_KEC, DATA_KELUARGA.NO_KEL, DATA_KELUARGA.TGL_INSERTION, Count(DATA_KELUARGA.NO_KEL) AS CountOfCOUNT_KK
FROM DATA_KELUARGA
WHERE (((DATA_KELUARGA.[tgl_insertion]) Between #2/1/2019# And #2/28/2019#))
GROUP BY DATA_KELUARGA.NO_KEC, DATA_KELUARGA.NO_KEL, DATA_KELUARGA.TGL_INSERTION;
mohon bantuan rekan2, sya ingin menghitung jumlah dari data_keluarga yg dikelompokkan berdasarkan no_kel, script yg sya pakai di atas running tapi hasilnya
Query1
NO_KEC |
NO_KEL |
TGL_INSERTION |
CountOfCOUNT_KK |
1 |
1001 |
2/6/2019 |
1 |
1 |
1001 |
2/10/2019 |
1 |
1 |
1001 |
2/11/2019 |
1 |
1 |
1001 |
2/11/2019 |
1 |
1 |
1001 |
2/14/2019 |
1 |
1 |
1001 |
2/14/2019 |
1 |
1 |
1001 |
2/15/2019 |
1 |
1 |
1001 |
2/25/2019 |
1 |
1 |
1003 |
2/6/2019 |
1 |
1 |
1004 |
2/14/2019 |
1 |
1 |
1005 |
2/11/2019 |
1 |
1 |
1005 |
2/25/2019 |
1 |
1 |
1007 |
2/27/2019 |
1 |
1 |
1007 |
2/27/2019 |
1 |
1 |
1008 |
2/27/2019 |
1 |
1 |
1009 |
2/12/2019 |
1 |
1 |
1009 |
2/12/2019 |
1 |
1 |
1010 |
2/7/2019 |
1 |
1 |
1010 |
2/26/2019 |
1 |
1 |
1012 |
2/7/2019 |
1 |
1 |
1012 |
2/14/2019 |
1 |
1 |
1012 |
2/27/2019 |
1 |
<tfoot>
</tfoot>
Namun yg sya maksud menghitung jmlah total dari no_kel = 1001 dan no_kec = 1
Terima kasih