Sequential Rec. Number of query Table

D

DMP

I have a table(Master)Name
--------------------
Buchanan
Callahan
Davolio
Dodsworth
Fuller
King
Leverling
Peacock
SuyamaSuyama

How can I generate RecNum column through Access SQL statement ?Out Will be
:RecNum LastName
----------- --------------------
1 Buchanan
2 Callahan
3 Davolio
4 Dodsworth
5 Fuller
6 King
7 Leverling
8 Peacock
9 Suyama
10 Suyama
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter in Crosstab query 3
Row headers instead of Column headers 5
Extract Headers from Crosstab query 2
Concatenate field data on two parameters 1
ImportXML doesn't give me a table 4
Frequency ( ) 2
What the Hell is going on here? 3
Subquery not integrating to query to display previous sum of quantities 3

Top