Add ID Number to every 1000 claims

[Steven547]

I have a request that i'm pondering on how to do. I have 100,000 claims. I want to assign a certain ID or Field for every 1,000 claims. So there will be 1,000 claims with the same ID, then the next 1,000 will have another ID. This is probably real easy and i'm thinking too much on it. Any suggestions? Solutions?

 

[Gnism]

If there is a sequential number in the table (i.e. SeqNum) create an id Field in your query similar to this:
NewID: Round(([SeqNum]+500)/1000)

Hope this helps...