Incrementing counter based on results

[senger.kim]

Hello World,

I'm relatively new to MS Access (2003) and am trying to implement
something that I feel should be simple but cannot find a solution.
Hoping that you can help me or point me where to seek more help.

Let's start with a hypothetical database:

ID Name
1 Peter
2 Paul
3 Paul
4 Paul
5 Simon
6 Simon
7 Mike
8 Mike
9 Mike
10 Mike

This is generated by a query I ran. Now I want to implement a counter
that will go through the "name" column and count the number of times a
specific name appeared. In this case, the result would be Peter - 1,
Paul - 3, Simon - 2 and Mike - 4. The ID column is not necessarily
always incrementing by 1 for the results were filtered from a much
larger database.

Is it possible to implement a counter which only increments if
specific criteria are met?

Thanks in advance for your advice.

Kim

[Keith Wilby]

<se********@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

Hello World,

I'm relatively new to MS Access (2003) and am trying to implement
something that I feel should be simple but cannot find a solution.
Hoping that you can help me or point me where to seek more help.

Let's start with a hypothetical database:

ID Name
1 Peter
2 Paul
3 Paul
4 Paul
5 Simon
6 Simon
7 Mike
8 Mike
9 Mike
10 Mike

This is generated by a query I ran. Now I want to implement a counter
that will go through the "name" column and count the number of times a
specific name appeared. In this case, the result would be Peter - 1,
Paul - 3, Simon - 2 and Mike - 4. The ID column is not necessarily
always incrementing by 1 for the results were filtered from a much
larger database.

Is it possible to implement a counter which only increments if
specific criteria are met?

Thanks in advance for your advice.

Kim

Yes, in query design mode click the Totals button. This will reveal another
row on the grid called Total. Set ID to Count and Name to Group By.
Incidentally, don't use Name as a field name, it's a reserved word and might
cause you problems.

Keith.
www.keithwilby.com