=========
QUESTION
———
I have a long number that I need to collect the 2nd, 4th, 6th, and 8th characters from.
=========
ANSWER
———
see EXAMPLES
=========
EXAMPLES
———
Store: Mid([SurvNum_Span],2,1) & Mid([SurvNum_Span],4,1) & Mid([SurvNum_Span],6,1) & Mid([SurvNum_Span],8,1)
=========
APPLIES TO / KEY WORDS
———
Microsoft Access
VBA
String Manipulation
=========
REF
———
http://ycmi.med.yale.edu/nadkarni/access_course/String_Frame.htm
—
http://www.anysitesupport.com/extract-every-other-character-from-a-string/
http://anySiteHosting.com