Query duplicate question

[kidrobot]

Okay you'll read this and think this is a really dumb question but bear with me please! I have a table with about 100k records. There is a field called "SN" and this feild is unique to it self. Although it is not a unique record in the table, this is because "SN" is count EVERY time it passes through a specific location. So for example say your car "SN" is 4545, and you drive through PA, then NY, then NJ. This table will count each event this happens. Then say this car makes the same trip through PA, NY, NJ so again the table will count 4545 for "SN". What I need to do is query only the duplicated so I can get rid of of all of them but 1. Sorry if this is confusing.

 

[Banana]

1) There's a Find Duplicate Wizard; in your database window, click on query tab and then click "New" button. A dialog box should come up with Duplicate Wizard as an option.

2) I'm not 100% sure, but it sounds like you have a design issue. Table isn't supposed to count something nor should it store calculated values. I'm also confused because you're saying that SN is unique but then is repeated... in same table? If that is the case, then yes, you do have problem with database design; look up normalization around here.