Can you add an autonumber field to a query

P

Paul S

Can you add/create an autonumber field in a query, such
that the results of the query are consecutively numbered
in the order specified by your sorting options?
 
R

Roger Carlson

On my website (see sig below) is a small sample database called:
"NumberedQuery.mdb", which illustrates how to do this.
 
Top