Find something in a field and find what is to the right

[fairyrak]

hi, I have a problem, I have a table and in that table the field f and record 2 says this

entity///physical entity///object, physical object

how do I tell access that I want the field g and record 2 to be "everything to the right of the last///?



I mean: object, physical object

[alansidman]

Put this expression in field g, ie. field g:=MID([field f],FIND(CHAR(1),REPLACE([field f],"///",CHAR(1),2))+3,LEN([field f])-(CHAR(1),REPLACE([field f],"///",CHAR(1),2)))

[fairyrak]

I can't use the formula because it's in English, how can I translate any formula to the language of my access easily?

[alansidman]

You will need to search google or some other Search Engine and find out what the function equivalents are in your language for your version of Access. I live in the US and work only in Access in English. Good Luck with your translations.