Query Link

[kitty77]

I have a field called [Link] and the data looks like this...
\customers\tomsmith\pdf\1234.pdf

In a query, how can I create a field that removes everything up to the pdf?
\customers\tomsmith\pdf

Thanks

 

[theDBguy]

You could use InStrRev() to look for the position of the last "\" and then use Left() up to that position.

 

[kitty77]

Can you show me how that code would look in the query?

 

[theDBguy]

Can you show me how that code would look in the query?

Maybe something like

Expr1: Left([FieldName], InStrRev([FieldName], "\")-1)

(untested)
Hope that helps...

 

[kitty77]

Works Great! One question though... The field [Link] is a hyperlink but when I use this code, it does not keep any hyperlink.

 

[kitty77]

Any way to make it a hyperlink too?

 

[theDBguy]

Any way to make it a hyperlink too?

So, you want the hyperlink to go to the folder, correct? Not to the file, right?

 

[kitty77]

Correct.

 

[theDBguy]

Correct.

How about?

FolderLink: "#" & Left([FieldName], InStrRev([FieldName], "\")-1)

Hope that helps...

PS. If you're displaying this on a form, you might have to set the IsHyperlink property to Yes.