separate the data

[DaRTHY]

Hello Friends,

In same field Im saving every time 6 digits data and i need to separate them. (It was not my fault. They created DB like this... :banghead

For example my data is

123412(main-field) and i want to see them 1234(field1) 12(field2)

hope so u can help to me. Ty for your helps

 

[CJ_London]

try

left(myfield,4) and right(myfield,2)

if you need the numerical values

val(left(myfield,4)) and val(right(myfield,2))

 

[DaRTHY]

Ty mate its working
in Internet i found
" FirstName: Left([FullName],Instr([FullName]," ")-1) " this code and i tried to modify but did not work.
But yours is working !!