Autonumber in Query

[DBFIN]

Is there a simple query expression that creates an autonumber field in the query. The field would work the same as an autonumber in a table where it sequentially assigns a unique number for each record and increases by 1 for each record ? I need to put this in a query rather than a table.

 

[khawar]

You can do it using DSum or by using subqueries but none of them is efficient so it should be used in table (my suggestion)