Mass Change in Database with IF statement in one column, change another?

  • Thread starter Thread starter Albert Einstein
  • Start date Start date
A

Albert Einstein

I have a database that has one column that has 3 values in it. Say
Value Bob,Tom, and Sam. In another column I have a hyperlink to
C:\111\temp.
I want to do a mass change to my database if the value in the first
value is Bob. I then want to change the hyperlink value to
C:\Bob\111\Temp.

Can this be done easily? Any help would be greatly appreciated!
 
Let's assume the field name for the names is MyName and the field name for
the second column is MyPath. Create a query based on your table. With the
query in design view, click on the Query Type button in the menu at the top
of the screen. Change your query to an Update Query. Put the following
expression in the second column where it says Update To:
Left([MyPath],3) & MyName & "\" & Right([MyPath],8)
Now run your query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top