access formula for an excel formula

  • Thread starter Thread starter tricia
  • Start date Start date
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
 
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?
 
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...
 
Back
Top