Access 2000 - Autonumber in a Query
Posted on 2011-09-26
Could you please advise is there way in Access 2000 to add an autonumber to a Query?
My problem is that the query has a certain ordering (in four fields like ascending, descending, descending, descending), and I would like to keep this order.
Basically I have a solution to change the query to make table and after adding Autonumber, but maybe the best would be if the query would be able to do it?