Tags Tags

adding a field in a make table query

December 10th, 2010 - 09:44 am ET by pat67 | Report spam
Help Create a new topic
Hello. I have a make table query that shows players ranked by their
winning percentage. What I want to do is when making the table add a
field to the front of table that is called "Rank" and is autonumbered
so that the highest percentage is 1 and the next 2 and so on. What I
am doing now is adding the field manually after I create the table. I
want to do it at creation since I have other queries I run off of this
table that have to wait until the "rank" field is there. Can someone
explain to me how to do this? Thanks
email Follow the discussionReplies 7 repliesReplies Make a reply

Replies

#1 pat67
December 10th, 2010 - 09:58 am ET | Report spam
On Dec 10, 9:44 am, pat67 wrote:
Hello. I have a make table query that shows players ranked by their
winning percentage. What I want to do is when making the table add a
field to the front of table that is called "Rank" and is autonumbered
so that the highest percentage is 1 and the next 2 and so on. What I
am doing now is adding the field manually after I create the table. I
want to do it at creation since I have other queries I run off of this
table that have to wait until the "rank" field is there. Can someone
explain to me how to do this? Thanks



One thing I will add is that I tried using a delete query and then an
append query but the problem with that is because the "Rank" field is
autonumbered, it starts with the next number. In other words we have
64 players so when i use delete and append, the first player now has
65 instead of 1. I need it to show 1 thru 64.

Similar topics

Make your own search :