automate id in queries-probably something very simple

[ymds]

hey, i created a column using alias and called it "average"

how can i add an automate number column in addition to the new "average" column?

[TheShabz]

you cant. The AutoNumber datatype in Access needs to be set at the very beginning (you cant change a num to autonum) and it cannot be used in conjuction with others, meaning you cant set 1 3 5 7 then want autonumber to take over from there with 8 9 10 11.

[ymds]

when i run some query it filters some of my records.
therefor i need in addition to the columns displayed by the query, a new column with autoNumber DT so i'll be able to see what is the new order of the records (1, 2, 3 etc..)

[TheShabz]

open the table in design view and just add the column name and choose autonumber as its datatype.

[ymds]

numbers will not be in 1, 2, 3 order... they might be 3, 6,8 etc...

[TheShabz]

If it's not going to be sequential, then autonumber isnt the proper tool to use for this. Is there a mathematical method in choosing the numbers? Or are they available somewhere else? If not, I really dont know of a way other than just opening the table up and manually adding in all the numbers you want.