Break data apart and fill in table fields 1

[ursino1]

Data is entered into -- field__1



Take A1234B56

(How do you tell it to?)

put A in field_2, and put 1234 in field_3, and put b in field_4.

 

[kerrigirrl]

have you tried using the Mid, Left and Right functions?

Left(Field_1, length from left)
Right(Field_1, length from right)
Mid(Field_1, start, length)

 

[ursino1]

thanx