Originally Posted by
charly.csh
Understand the point with the autumber. How do you add a new field like this? or what should be the logic sequence of this?
Create a query based on your table and add a new field in this query with the expression below:
Code:
SN: DCount("ID","YouTableName","ID<" & [ID])+1
For example, in SQL view:
Code:
SELECT DCount("ID","YouTableName","ID<" & [ID])+1 AS SN, Field1, Field2, Field3 FROM YouTableName;
(change the "YouTableName" with the actual name of your table)
Keep the actualy ID for the database and the SN only for your eyes.
Cheers,
John