jjxia2001
asked on
Need help to format text field in ACCESS data table
I have a field in an Access table to show three quotes such as this: """0-2,500""". I want to change it to "0-2,500". How do I delete the extra ". The length in the middle is not same, may have """2,500-5,000""" or """5,000-10,000""".
I tried MID function, but need the length: MID(fieldName,3,length), length is varied.
Please help
I tried MID function, but need the length: MID(fieldName,3,length), length is varied.
Please help
Last Comment
jerryb30
Try replace(replace(yourField,
ASKER
Got invalid syntax error.
SOLUTION
THIS SOLUTION IS 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.
Try replace(replace(yourField,
jerryb30,
I think you are missing some concatenation operators :)
Patrick
I think you are missing some concatenation operators :)
Patrick
jjxia2001,
Did you try either of mine?
Patrick
Did you try either of mine?
Patrick
SOLUTION
THIS SOLUTION IS 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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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.
ASKER
All three ways worked, but I like the one from buttersk. Thanks all!
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
