[ask] ms access expression get text after multiple "/"

[threadbooster]

hello i want to ask something
currently i have access table field like this

|folder |
|C:/aaaa/bbbb/cccc/dddd/eeee/fffff/gggg/|
|C:/aaaaa/bbbbb/ccccc/ddddd/eeeee/ffffff/ggggg/|

i want to add "subfolder" field , that the value from "folder" field text after 4th char "/" before 5th "/" and the result will be like this

|folder | subfolder
|C:/aaaa/bbbb/cccc/dddd/eeee/fffff/gggg/| dddd
|C:/aaaaa/bbbbb/ccccc/ddddd/eeeee/ffffff/ggggg/| ddddd

how i write an expression to get this value

please kndly your help

thx

 

[PeterF]

split(folder, "/")(4)

 

[MarkK]

And don't add a field to your table. Write a query ...

SELECT Folder, Split(Folder, "/")(4) As SubFolder
FROM tblTable

 

[threadbooster]

And don't add a field to your table. Write a query ...

SELECT Folder, Split(Folder, "/")(4) As SubFolder
FROM tblTable

where i put this code in access query ?
please help

 

[threadbooster]

And don't add a field to your table. Write a query ...

SELECT Folder, Split(Folder, "/")(4) As SubFolder
FROM tblTable

where i put this in access query form ??

 

[threadbooster]

And don't add a field to your table. Write a query ...

SELECT Folder, Split(Folder, "/")(4) As SubFolder
FROM tblTable

where i put this in access 2010??

 

[PeterF]

In a new colum in the field row copy:

SubFolder:Split(Folder, "/")(4)