Need Update Query to copy info from one field to another

[keun]

I imported a bunch of data into a table. One field is a bunch of filenames... File001.txt for example.

All the files named are in the same folder.

I created a new field, formatted as hyperlink, and I want to take the date from the filename field and put it in the new hyperlink field, but I need to make sure the hyperlinks point to the path + the file name

for example, the new field will display and link to:

server\folder\File001.txt

THANKS!

 

[VRoscioli]

How about:

UPDATE tblTable SET [[i]HyperlinkField[/i]] = "[i]\\your\path\[/i]" & [[i]FilenameField[/i]];

-V

 

[keun]

OK that works. But my hyperlinks are not working. I will make a new post on this second question.