Renumber a query

[flofi]

Hi

Probably an easy thing to do. I have a query with different names which are numbered. But there are some numbers missing, like this:

name number
Joe 1
Joe 3
Joe 4
Joe 6
Tom 1
Tom 4
Tom 5
...

How can i renumber the query without using vba to get this?:

name number otherNumber
Joe 1 1
Joe 3 2
Joe 4 3
Joe 6 4
Tom 1 1
Tom 4 2
Tom 5 3
...

Thanks for your help

flofi

 

[ByteMyzer]

How can i renumber the query without using vba to get this?:

Why? Do you have something against VBA???

Seriously, this can not be effectively done without VBA.

What exactly are you attempting to achieve?