Autonumber in a Make Table Query

[cterjesen]

I have a query that builds a table. This query ranks the company's sales representatives by their monthly production volume. A report is then built off of the table created by this query. I have to go into the table after it is built and add an autonumber field. This field is used as the rank # of the salesperson (highest volume = rank of 1, next highest = rank of 2, etc.).

Is there any way to create this autonumber field in the make table query so that I don't have to go and add this to the table afterward?

Thanks!

 

[Joe4]

You should be able to create your report directly from the query without having to make a table. Check out this article from the MicroSoft Knowledge Base: http://support.microsoft.com/default.aspx?scid=kb;en-us;208946&Product=acc2000

You can also find other threads dealing with this issue if you use the Search functionality on this site and search on the words "rank query".