[AccessD] Simple String Help

I know this should be easy, but for some reason today I just can't come up
with a working solution..


The Goal:  To evaluate a string (path) and return only the end (last folder
name).

This string could end differently with or without "\"

Example: "\\adfs\ad_folder\sxpdata\Word Docs\" OR
"\\adfs\ad_folder\sxpdata\Word Docs OR C:\ad_folder\sxpdata\Word Doc\

Need to return only the "Word Docs" portion

I'm drawing a blank here....


WBR
Robert