exctracting characters from a field 1

[RTKarkivi]

hi to all,


my case is like this: I want to exctract some characters from field1 and some from field2 in order to create another field based on that. I try this; Left([field1],3)& left([field2],3} but it takes all the all 3 characters from left. I am interested to take just the third one, not the first three ones. I would appreciate if anyone can help me fix this problem.


Thanks in advance,

 

[PHV]

take just the third one
Mid([field1],3,1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RTKarkivi]

thanks a lot,
it helped me a lot