Software
by ddevans888
It's saying you will throw some of your data away if you do this, you might not care, but it's not something you'd want to do by accident. What you do now depends on the data.
Select Distinct SerialNumber from MySerialNumbers will tell you how many would be left with no duplicates.
Select Distinct Row from MySerialNumbers would tell you how many exact column for column duplicates you have.
If the number of records reurned in the above two queries is not the same, you need to decide how to choose one row over another such as say if you had DateCreated in there you could choose to keep the most recent one. Access can't do that for you automatically though, you need to make the decision(s).
My preferred solution is to create another table with the structure required and then select into it. Once you've got all the data you need, then you can delete the original and then rename the new version back to SerialNumbers or whatever it was called.
For investigation purposes.
Select SerialNumber, Count(*) as NumberofNumbers from SerialNumbers Group By SerialNumber
Then select from that a list of serialnumbers where NumberofNumbers > 1 will give you a quick way of examining what sort of duplicates you have.
by ddevans888
That did the trick duplicate erradicated.
Nordite
I think the Serila Number field has been set autonumber . which is the reason it doens not allow u to change the value.
I can do some changes in ur application and get it working for you, if u r interested.
Pls feel free to contact me.
Pooja
This discussion is closed to new replies.
Sort by Trending