Hi everyone,
I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this:
I am wondering if there is a way to run an update query which would automatically fill in the blank fields in column 2. The numbers in column 1 will always correspond to the same person in column 2.
Thanks,
Chris
I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this:
Code:
API# Current Operator
---------------------------------
1 |
1 |
2 | Bob
3 | Joe
1 | Mike
3 |
2 |
I am wondering if there is a way to run an update query which would automatically fill in the blank fields in column 2. The numbers in column 1 will always correspond to the same person in column 2.
Thanks,
Chris