Update Query

[2624]

I would like to update partial Hyperlink fileds in Update query. For example existing fields starts with \\Fs3 but I want to replace with D:\ and keep rest of the hyperlink(text in the field)

Existing records looks like this:
\\Fs3\agency public data\Project Plans\AF\Cameroon\Plan\FY 04\AF-PP-FINAL-June041.doc

I want to update to:

D:\agency public data\Project Plans\......

I use Access 2000. Thank you for your help.

 

[lespaul]

something like this should work.

First run a select query and see if you get the correct results:

SELECT FieldName, "D:" + Left(FieldName, 5) From tblName

if that shows the correct information, then you can run an upate query:

update tblName set FieldName = "D:" + left(FieldName, 5)

Leslie