help with access query - numerate on table (1 Viewer)

[E_Gold]

hi

i neet to numerate my table from 1 to when ID change.
for example i have this table:

ID | Name
======
11 | AA
11 | BB
11 | CC
11 | DD
22 | EE
22 | FF
33 | GG
33 | HH
33 | AA
33 | DD
44 | ZZ

and i need to see this:

NUM | ID | Name
============
1 |11 | AA
2 |11 | BB
3 |11 | CC
4 |11 | DD
1 |22 | EE
2 |22 | FF
1 |33 | GG
2 |33 | HH
3 |33 | AA
4 |33 | DD
1 |44 | ZZ

how to do it ?

thanks in advance

 

[John Big Booty]

Perhaps the attached sample will give you some pointers.

 

[E_Gold]

thanks for the help, but i cant see something that will help me

 

[John Big Booty]

It's all there (you will need to tweak it a little ). If you want more info check here and download the sample form here.