I'm not sure the best way how to phrase the question (otherwise I would have better luck searching for a solution) so please look at the visual.
I am looking for a way to create a count of record instances in a table.
EX:
Starting point -
RecordID Value
1 X
1 Y
1 Z
2 X
2 Z
3 A
Desired result - I want a new column that gives the count of records for a RecordID (below):
RecordID Value RecordCount
1 X 1
1 Y 2
1 Z 3
2 X 1
2 Z 2
3 A 1
I can do this in VBA but I feel like there is a way to do this in a query.
Thanks in advance for your help,