Access 2000 Update Query (9.0.2720)

Topic

New Reply

Hello All: I am trying to run an update query in which I build the ‘update to’ field with the following line (a hyperlink):
“ps109fsr1xbasetraffic-odpscrashreports” & [docno] & “.tif”. All looks okay after I run the query and the field is updated with the proper looking hyperlink. However, when the link is clicked, nothing happens. If I manually retype the hyperlink in the field, all works well. However, I have 44,873 of these links to images and I would rather not have to have some one manually type them all. What am I overlooking here? Any and all suggestions are welcome. TIA.

Reply | Quote

Replies

You have to add a # before and after the string :
“#ps109fsr1xbasetraffic-odpscrashreports” & [docno] & “.tif#”

Reply | Quote

Francois: Thank you very much. That was the solution.

Reply | Quote