I have a field that contains a file path. I need to return just the last part of the path in a query i.e. the string after the the last / .

Can anybody help with an easy way of doing this.

Thanks

after A97, you get a split command - so try this

dim myarray 'i thing it should be a variant
dim filename as string

myarray = split(mypath,"/")
filename = ubound(myarray)


-------
othewise you can find the position of the "/" with instr, or instrrrev (later versions), then use mid or right function to retrieve the filename

Thanks for your reply. I should have said I'm a nooby to this. Where would I put that in the query ?