Sequence

[garygdj]

I have duplicate loan numbers in a table. I want to create a query that will assign a number so the the duplicates will have a new field called sequence.
example

LNNUM SEQ
999999 5
999999 4
999999 3
999999 2
999999 1
888888 3
888888 2
888888 1
777777 2
777777 1

Any suggestions?

 

[FoFa]

I would create a function that does this, working on a single loan number (parameter). This way you can control what happens much better. You can create a unique loan number query that only returns loans with duplicate numbers and use that to call the functions as an example.

 

[garygdj]

I figured it out! I had already created a query that returns duplicate loan numbers when I got your message. I also had to create another table that contained the sequence series that are possible. In this case I only had to create 5. Queried them against each other and dumped them all back into a new table.

Though this is probably not the best solution particurally if this was being done on a larger scale, it serves my purposes.

Thanks for your help