Autofill Query?

[ccflyer]

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:

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

 

[KeithG]

Why do you need to fill them in?

 

[ccflyer]

I originally wanted to fill them in so all the records would be complete in a report. Can I get by without filling them all in?

-Chris

 

[KeithG]

couldn't you make another table for the operators and associate the API # with an name?

 

[ccflyer]

I guess I could do that... But wouldn't I still have to fill in the blank fields?