Find equivilent in Access

[Smudger Smith]

Anyone?

Here is my dataset example:

\a1234
blah\a1234
\a123456
etc - I'm sure you get the idea ;o)

I need a way to capture JUST the characters after the "\"

I have not used Access 'properly' in over a year so i am more than a bit rusty.

Thanks for your help

 

[Smudger Smith]

oh - yeah - should have said - I want to do this in a query and NOT vba - Thanks
Excel equiviemt would be =mid(a1,((find("\",A1)+1),99)

 

[Atomic Shrimp]

It's pretty similar in Access:

Mid([YourFieldName],InStr([YourFieldName],"\")+1)

If you miss out the last parameter from the MID statement (the length you want), you get the rest of the string (equivalent to your 99, but works if there are more than 99 characters left)

 

[Smudger Smith]

Thanks Mike - Great and speedy response!