renameing jpg's

[Guest]

Hello,
I have a problem.
I have a table with 500 path names to JPG's that I want to rename to another
column on that same table.
for example:
c:\Documents and Settings\User1\1.jpg is on one of the cells
and "Tree" is on the other cell in the same row
I want to change it to:
c:\Documents and Settings\User1\Tree.jpg
now, it would have been easy if it was 1 or 2 records but I have 500

can I do it on access?

Thanx in advance
Joe

 

[Van T. Dinh]

Try a Query similar to:

UPDATE [YourTable] AS T
SET T.Field2 = Left( T.[Field1], InStrRev( T.[Field1], "\" ) ) &
T.[Field2] & ".jpg"

InStrRev() function is available only in A2000 and later. If you use
earlier version, it is a bit more messy but still doable.