Can you please advise how to add autonumber to a query?
So for example if there is a table with three records with headers "Item" and "Qty"
then the autonumber would be 1 for the first record, 2 to the second and so on.
Basically I have no chance to put this to a table, because there are several ones and linked to the access as outer excel and text files. So there would be needed to calculate in a query