Assigning Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSHO - 14 Mar 2006 16:21 GMT

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

Reply to this Message

mscertified - 14 Mar 2006 16:54 GMT

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

> 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

Reply to this Message