How to cut second and third letter in one column records (1 Viewer)

xytras

New member
Local time
Today, 00:03
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
 

FoFa

Registered User.
Local time
Today, 02:03
Joined
Jan 29, 2003
Messages
3,672
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

Top Bottom