access formula for an excel formula

T

tricia

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

A3 being a field in access
 
G

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?
 
T

tricia

Great

Gummball said:
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?
Click to expand...
 
Top