Access table row numbering

I want to create a query and to create a column numbered 1,2,3 …n where n is the number of rows. Is there a function to do this? I normally have to use VB to run down the bast table and put a sequence number on each row, but this seems clumsy!