Restart auto number after deleting records
The autonumber is my primary key and doesn't really have anything to do with the other data in the table (i.e. I don't care if the auto number changes on a record, provided the other data doesn't change).
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The autonumber is my primary key and doesn't really have anything to do with the other data in the table (I.e. I don't care if the auto number changes on a record,
I am sure Im not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question
In the property sheet I chose Limit To List "Yes".
I can only add the words good, bad or unknown, which was my goal. But access creates new records into my querry. When I chose unknown it saves unknown [auto-number 4]. So the next time I can choose between good [auto-number 1], bad [auto-number 2], unknown [auto-number 3] and unknown [auto-number 4].
Therefore I save the information but I cannot use it in the end because every record has a different auto-number.
Can someone please help me, I already spend 6h try and research on the internet but I could not find an answer
We used auto numbering for each record, the auto number is the first field in the database ( I believe this is my primary key as well). when a user deletes a record - say record 4 for example - the database does not renumber the records it just shows the records in order as 1, 2, 3, , 5, 6, etc. skipping number 4. So this puts my users in a position where they have no idea how many actual records are in the database.
Is there a way to have access re-number the records? I assumed when I setup auto numbering for column 1 that it would do this.
However - I have an auto field - record number - this obviously remains at the number of the last record in the (deleted) database.
Can I re-set the numerical origin of this field to start again at one ? Or do I have to delete it and set up another auto record number field ?
This is not an urgent enquiry - probably a bit basic for many on the forum - but just to add to my knowledge of Access.
Fields: Autonumber (Primary key), [SUbmission Number 1], [Submission Number 2], Relationship
Using Access 2002
I want to remove duplicate records where for two records, [Submission number 1], Submission Number 2] and Relationship are the same. It is easy to find the duplicates, but is there any wayto remove one of the duplicate records?
Next time if I enter a record I want the is to be 91.but its as 101.