Separate one field into two fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 17 Feb 2006 17:08 GMT

Hi,

I have an ID text field that is composed of two alphabetical letters
and the rest are numbers. This field is also a primary key. In this
same table, I want to separate this field into two fields. Then make
these two new fields primary keys. The first just contains the two
alphabetical letters. The second contains the numerical digits. Is
there a way to do this without losing current data?

Thanks,

Tony

Reply to this Message

fredg - 17 Feb 2006 17:31 GMT

> Hi,
>
[quoted text clipped - 8 lines]
>
> Tony

Add 2 new fields to your table, [LetterPortion] and [NumberPortion] as
Text datatypes.

You can run an update query after you added the two new fields to the
table.

Update YourTable Set YourTable.LetterPortion = Left([TextField]),2),
YourTable.NumberPortion = Mid([TextField],3);

Change the field names however you want.

Both the letter and number portions are still Text datatype and you
still have your original ID field.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message