access formula for an excel formula

[tricia]

ow do this in access
=RIGHT(A3,LEN(A3)-FIND("\",A3,FIND("\",A3,FIND("\",A3)+1)+1))

A3 being a field in access

 

[Gummball]

What is it you're trying to accomplish? This formula won't work in Excel as
the outermost find is being given too many arguments (as is the first nested
find).

For example, if you have the text:

"Today\Is\Great"

What would you want the function to return?

 

[tricia]

Great

What is it you're trying to accomplish? This formula won't work in Excel as
the outermost find is being given too many arguments (as is the first nested
find).

For example, if you have the text:

"Today\Is\Great"

What would you want the function to return?