sort alphabetically then number 2

[kkson]

Hi, Need a little help.

I need a number field, can't be an autonumber. That will number consectively, alphabetically from A to Z. (andrews = 1, buns = 2, chan= 3 and so on). now if i delete buns(2) I need to requery the table and now andrews =1 and chan=2. If i have 20 names and then add adams, adams should now be 1. so i need to requery and renumber. can this be done. Autonumber would have adams as 21 and i can't make him 1.

Thanks for any help.

 

[kkson]

okay figured it out. Made the query a make table query then updated the row# from that table.

Thanks for the help!