Any quick easy way to add AutoID to query

[mrchonginhk]

I have a query result and I want to add a new column called ID to be like this, simply, 1,2,3.. etc

Pls help how to do it quick. Thanks a lot.

 

[ajetrumpet]

well you can do yourself a favor by adding an autonumber to your table that you pulled from. if you don't have one, copy it into a new table where an autonumber already exists. then you won't have to worry about dynamics in the future.

 

[mrchonginhk]

well you can do yourself a favor by adding an autonumber to your table that you pulled from. if you don't have one, copy it into a new table where an autonumber already exists. then you won't have to worry about dynamics in the future.

The problem is the data source is an external data.
So the table itself does not have datasource. What can we do here ?

 

[Joe4]

Well, there is a way to do it, but it is extremely volatile and unstable, and I would not recommend doing it.

What is the reason you need this? If we know what you end goal is here, we maybe able to provide some other suggestions.

 

[mrchonginhk]

My case is:
My table is a linked external source with no auto number
I need to assign one in Access.

Thanks

 

[xenou]

All I can think of is to load the data to a temporary table that does have an autonumber key? I.e., run a make table or append query when you need the data. But this is curious - if there is no such sequence in the original table what purpose does it serve in the query? I don't believe I've run across this before.

ξ