I think this is a very simple question, that (I think) is asked a lot before,but I don't know the correct search terms...
. The searchresults I get are to complexed to understand for me (at this moment): I first need to start simple with this.
I have recordset that has the following fields:
Name number
Example:
Name - number
Bla - 1000
bla - 1005
bla - 1100
blo - 1200
blo - 1210
blu - 900
blu - 950
blu - 960
What do I want as result?
Name - number - count
Bla - 1000 - 1
bla - 1005 - 2
bla - 1100 - 3
blo - 1200 - 1
blo - 1210 - 2
blu - 900 - 1
blu - 950 - 2
blu - 960 - 3
So: If 'Name' is a new value, 'count' should start with '1'
If 'Name' is the same, count should be '1 + 1' etc.
Can someone help me how to do this? Or give me the search terms I should use.

I have recordset that has the following fields:
Name number
Example:
Name - number
Bla - 1000
bla - 1005
bla - 1100
blo - 1200
blo - 1210
blu - 900
blu - 950
blu - 960
What do I want as result?
Name - number - count
Bla - 1000 - 1
bla - 1005 - 2
bla - 1100 - 3
blo - 1200 - 1
blo - 1210 - 2
blu - 900 - 1
blu - 950 - 2
blu - 960 - 3
So: If 'Name' is a new value, 'count' should start with '1'
If 'Name' is the same, count should be '1 + 1' etc.
Can someone help me how to do this? Or give me the search terms I should use.