Adding Unique Numbers to Half a table

[colmtourque]

I have a table with some 2 thousand records.
I would like to number about half and then have any duplicate records numbered the same.
Is there any way to do this using an append query.
Thanks in advance.

 

[dcx693]

First question: why?

Without having to jump through hoops, the best way is probably using VBA code along with DAO or ADO. In English: you'll need to write code to number the records for you.

There are some non-code ways to do it. Like, splitting your table with the dupes in one half the non-dupes in another, add an autonumber field to the one unique half. Using an append query to the other half. Then change the autonumber field to a regular number field and marrying the two.

 

[colmtourque]

Thanks

Honestly before I'll do that I'll export what I want into excel and drag. Then import it back.
Same thing but probably a little faster.

Why? Because I'm in need of a unique field on which to key the database and it does not have one.
The duplicates are not fully duplicates, but the contain enough data that does duplicate.
Without getting to into the conversation they contain policy numbers, but the policies might pertain to multiple people.