split record

[y2k]

OK, I've searched and searched and searched but I can't find the answer to this question. I have a field which is 6 characters long. I need to get the middle two, how do I do that? The source of the original field of 6 characters is out of my control so i can't change that, i need to create a new field in a query that'll pick up the middle two charactes. I know how to get the last 2 and first two etc by using Left([field name],2) but not the middle two. I tried left([field name],2,4) but no joy. please, can anbody help?

 

[Mile-O]

Mid([YourField], 3, 2)

 

[IgorB]

1) Left(Right([Field],4),2) or
2) Right(Left([Field],4),2)

Mid Function is definitly better!!

Best Regard.
Igor.