Query that result incremental number, with no Auto-Number

[alvaro_xav]

Well, here's my database :

Name : String
Address : String

I want to add an automatically generated column, "no.", to show which number it's in. Like this :

No. Name Address
1. A Unknown
2. B Unknown2

The problem is, I can do that with Auto-Number, but if the user delete row 1, the number in row 2 is still 2, not 1.

Is it possible to generate query that have "no." column in it ?

 

[statsman]

Personally I don't know if you can do it with re-sorting the table.
I will be watching the input from others with great interest. It was somthing I wanted to do myself some time ago and I finally gave up.