Hey all,
So I have a table with 2 fields.
The first field has the addresses to multiple hyperlink paths to folders on my computer.
In this field the display text matches the hyperlink paths.
In the second field I have the desired display text for field 1.
I have tried using an update query to either:
1) Change the display texts of field 1 to match field 2 while preserving the hyperlink path
2) Add the hyperlink path from field 1 to field 2 without altering the display name.
I cannot get either one to work. Upon updating field 1, I lose the path, and upon updating field 2, I lose the name.
Can anyone help me out?
Thanks!