Hi,
I've a table containing a number of records with duplicated keys like that shown below
TRef TTID
1 11
1 24
1 6
2 9
2 14
3 8
I would like to count each TRef in that table and write them into another table as summaried below with MS ACCESS VBA
TRef Count
1 3
2 2
3 1
Any suggestions are welcome.
I've a table containing a number of records with duplicated keys like that shown below
TRef TTID
1 11
1 24
1 6
2 9
2 14
3 8
I would like to count each TRef in that table and write them into another table as summaried below with MS ACCESS VBA
TRef Count
1 3
2 2
3 1
Any suggestions are welcome.