Populate unique count as per item in access using vba
Hi Guys,
An access table has the following data
Mat
MAT
Mat
mAt
mAt
maT
I want to write vba program in access to select unique records with their counts and place them into a another table in access either using macro builder or code builder.
And then the expected output will be:
Mat â 2
MAT â 1
mAt â 2
maT - 1
Much appreciated for your answer,
Thank you,
|
