How can i create a field like autoincrement in Access ?
I want to have a serial number e.g. 1 to 9999999 and while appending a new record it automatically increments itself by one. I think it is done by Identity , but how? How is it used. Explanations are appreciated..