troubleshooting Question

MS Access Query Invalid Procedure Call InStr([xxx],"y")-1

Avatar of Gary Croxford
Gary CroxfordFlag for United Kingdom of Great Britain and Northern Ireland asked on
SQL
2 Comments1 Solution774 ViewsLast Modified:
Thank you for looking at my question,

I am querying a table in access that has a text field containing data strings of varying lengths.
I am trying to separate out the first part of the string - nominally the first 16 to 19 characters followed by a semi-colon.

To achieve this I have tried the following:

ItemName: Left([Description],InStr([Description,":")-1)
and
ItemName: Left([Description],(InStr([Description,":")-1))

but both return an invalid procedure call message.

ItemName: Left([Description], InStr([Description,":"))
returns the string I need and the semi-colon

What have I missed?
ASKER CERTIFIED SOLUTION
smilitaru

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros