I have a database that has only the user id field on the 1st record and i
need to fill in the user id on the subsequent records. until it hits the next
User ID, in the following example i need user ID 100 to be copied into the
next 2 rows

user id name code Amt
100 Wayne A 20
C 12.5
X 9
104 Doe A 19
H 11
200 wright A 15
206 Jones B 7
x 10
400 Marsh D 5