Can I add ".gif" to lots of records at the same time???

[sammx]

Hi all,
In my access file, there is a field called "image" which stores image file name. As you know, those files should be ended as ".gif" or ".jpg"...etc. However, I forgot to add ".gif" to all those files.
Is there any ways that I can add ".gif" to those records at the same time?
For example:
image ==> image
12345 12345.gif
56845 56845.gif

Thanks a lot,
Sammx

 

[Zeroanarchy]

Yea setup an append query as follows

yep create an update query

Field = images
table = table name
update to = [images] & ".jpg"

hope this helps

Zero Anarchy

 

[Zeroanarchy]

just so you are aware do not run the query more than once else you will end up with 1212.jpg.jpg and each time you do it, it will continue to add .jpg to the end.

 

[sammx]

Hi Zeroanarchy,
Thanks for your help!
I try to input:
Field = image
table = books
update to = [image] & ".jpg"

into a query with SQL statement.
But there is an error: invalid SQL statement....expected to be "Select" "Procedure" "Delete".....

Thanks

 

[Zeroanarchy]

UPDATE books SET books.image = [image] & ".jpg";