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\Databas
B:\Dropbox\Business Documents\Database\Databas
B:\Dropbox\Business Documents\Database\Databas
B:\Dropbox\Business Documents\Database\Databas
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]"
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?
B:\Dropbox\Business Documents\Database\Databas
B:\Dropbox\Business Documents\Database\Databas
B:\Dropbox\Business Documents\Database\Databas
B:\Dropbox\Business Documents\Database\Databas
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]"
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?
Microsoft Access
Last Comment
Dale Fye
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect as always. Thank you!
You are welcome. Glad I could help.
Public Function get_imgpath()
get_imgpath=DLookup("[Imag
End Function