About
Pricing
Community
Teams
Start Free Trial
Log in
micky running
asked on
7/31/2015
Have 4 Letters field Like ABCD but just need AC how can do it?
HAVE 4 letters ABCD
how can a just select the positon AC or AD ?
Microsoft Access
3
1
Last Comment
micky running
8/22/2022 - Mon
Jeffrey Coachman
7/31/2015
Define "Position"....
In other words, ...for the text you provide, what do you want the result to be?
The position of a "A" wold be:
Instr(YourString,"A")
...will return: 1
Instr(YourString,"D")
...Will return 4
ASKER CERTIFIED SOLUTION
Kanti Prasad
7/31/2015
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
micky running
7/31/2015
ASKER
GOOD TO GO!
Your help has saved me hundreds of hours of internet surfing.
fblack61
In other words, ...for the text you provide, what do you want the result to be?
The position of a "A" wold be:
Instr(YourString,"A")
...will return: 1
Instr(YourString,"D")
...Will return 4