(Access 2000)
How can I create a field that contains sequential numbers that automatically update when fields are deleted, and that automatically add numbers to records that are appended? Said another way...
I want a field (let's call it Number) in a table that, for successive records, contains: 1, 2, 3, 4, 5...
If I delete row 4, I'd want it to automatically adjust/refresh to go to 1, 2, 3, 4 (not 1, 2, 3, 5).
Then (and this may be a different procedure), if I append new records to this table, the numbers 5, 6, 7...etc get added.
Is this something that is...
a) set up so that it does it automatically (I know, I'm dreaming, but... a guy's gotta dream...)
b) done via a query (can't figure out how to do such a simple calculation...)
c) done via SQL or VBA
Thanks!
Martin Lacoste
How can I create a field that contains sequential numbers that automatically update when fields are deleted, and that automatically add numbers to records that are appended? Said another way...
I want a field (let's call it Number) in a table that, for successive records, contains: 1, 2, 3, 4, 5...
If I delete row 4, I'd want it to automatically adjust/refresh to go to 1, 2, 3, 4 (not 1, 2, 3, 5).
Then (and this may be a different procedure), if I append new records to this table, the numbers 5, 6, 7...etc get added.
Is this something that is...
a) set up so that it does it automatically (I know, I'm dreaming, but... a guy's gotta dream...)
b) done via a query (can't figure out how to do such a simple calculation...)
c) done via SQL or VBA
Thanks!
Martin Lacoste