Assigning Values

[Guest]

I am trying to fill in values of a table that already has data in it. I want
to assign a tracking number to a field which has some blanks. I want the
number to be CTW 1, CTW 2 and so on. How do i do this?

Thanks in advance

 

[Guest]

Assuming this is a one-time operation, if there are not too many, you could
just do it manually. Otherwise you could write a function to do it via a
query.
Why use the 'CTW' prefix, since it is a constant it is superfluous, you
could easily add that when the data is displayed on a form or report.

-Dorian