Hi all. Just when I thought I was finished I realized that my table, in the hyperlink field, doesn't have the base address in each link. E.g.
I have:
040F-CY181824-MS.JPG
where it should be
T:\SHARED FILES\Administration\Masters and Molds Photos\040F-CY181824-MS.JPG
Since I have over 2000 records I tried to use the below update query but it only updates the "text to display" field and not the acutall "Address". It's supposed to do both.
Can some1 tell me what I'm missing?
Left([HyperLinkField],InStr([HyperLinkField],"#")+56) & [Photo] & "#" & Left([HyperLinkField],InStr([HyperLinkField],"#")+56) & [Photo]
56 is the number of characters of the base address. If I leave 1 it only puts the " T " into the address.
Thanks!