How can you sort an access 2003 table in asending order so that it goes 1,2,3,4,5,6,7,8,9,10,11,12.... etc. As of now it sorts 1 through 9 correctly, but when 10 is added it sorts it 1,10,2,3,4,5,6,7,8,9. Thank you.

It sounds like your field is text rather than numeric. Is changing it to a numeric type an option? By the way, I wouldn't sort at the table level anyway; I've heard of performance problems. Sort at the form/query/report level.