Link to home
Create AccountLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

How design query to update field values in a table

I have a table with several records that have the following examples in a field named "Image":

B:\Dropbox\Business Documents\Database\Database Images\Tree.jpg
B:\Dropbox\Business Documents\Database\Database Images\Football.jpg
B:\Dropbox\Business Documents\Database\Database Images\Rainbow.jpg
B:\Dropbox\Business Documents\Database\Database Images\Flower.jpg

But I want to create an update query that will chance the text in the field to be a lookup from a table and the last part of the existing field value.

So if the lookup value is...

= DLookup("[ImageDirectory]", "tblDatabaseSetup")

Then I want the new field values to read:

The Looked Up Value\Tree.jpg
The Looked Up Value\Football.jpg
The Looked Up Value\Rainbow.jpg
The Looked Up Value\Flower.jpg

In other words the field should display the looked up value and keep the last part of the existing value for example Tree.jpg

How can I create this update query?
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I recommend to do a Public Function and use it in the SQL for the query

Public Function get_imgpath()
    get_imgpath=DLookup("[ImageDirectory]", "tblDatabaseSetup")
End Function
Avatar of SteveL13


Perfect as always.  Thank you!
You are welcome.  Glad I could help.