R
Randal
I have a table where some of the values in the ID field are duplicated
because it is the many side of a 1 to many. What I need to do is run a
query that will assign a line number to each record. Is there a way to do
this? I don't really care about the order or which line is assigned the 1.
Example:
ID Line
101 1
101 2
101 3
102 1
103 1
103 2
because it is the many side of a 1 to many. What I need to do is run a
query that will assign a line number to each record. Is there a way to do
this? I don't really care about the order or which line is assigned the 1.
Example:
ID Line
101 1
101 2
101 3
102 1
103 1
103 2