How to cut second and third letter in one column records

xytras

New member
Local time
Today, 02:11
Joined
Oct 5, 2005
Messages
9
Hi!
I have one column with text field
I would like to know how to cut for. example 2nd and 3 letter in records collected in this column?
Thanks in advance for any examples
 
if you want to pull out the 2nd and 3rd you can use MID([mycolumn],2,2), you can use this in a query or in VBA, in VBA it would be MyVar=MID(something,2,2)
 

Users who are viewing this thread

Back
Top Bottom