Hi,
I am running a select query that identifies added riders on our system. It produces the fields policynumber, name and dob. When there is more than one added rider i get 2 rows which have the same policynumber and different name and dob. What i would like to do is assign a number to each row so the top row would be 1 and the next 2 and if present the next would be 3 for the multiple rows under the same policy number.
Hope that makes sense.
Many thanks
I am running a select query that identifies added riders on our system. It produces the fields policynumber, name and dob. When there is more than one added rider i get 2 rows which have the same policynumber and different name and dob. What i would like to do is assign a number to each row so the top row would be 1 and the next 2 and if present the next would be 3 for the multiple rows under the same policy number.
Hope that makes sense.
Many thanks