how to.........

[LIN]

my problem is to move a field's(say field_1) leftest 2 characters into a new field(say field_2) within same record. but how ?
note : field_1 have more than 2 characters,& is a field of string, so does field_2.
thanks for all who can tell me.

 

[AlaskanDad]

I wouldn't recommend duplicating any data within the same record let alone the same table. You should just reference the first two letters in Field_1 whenever you need them instead of moving them. You can reference them using the following:

Left ([Field_1),2)