Record number for a new table

[Peter Bellamy]

I am making a table selecting certain records from a bigger table.
I would like the new table to have record numbers, starting at 1.
Is there a simple way to do this?

Cheers

 

[Peter Bellamy]

On the basis of no suggestions I have decide that I will:
Count the number of records, n, in the new table
Create another second new table with just 1 to n in it,
and then join them with a Union query.

pnb

 

[ByteMyzer]

In the Microsoft Access Help File, search for AutoNumber