Find and replace

[Guest]

Hello,
I export a file in on a monthly basis and use the information to create a
report. The problem is that one of the fields the information is more than
27 characters and causes problems with the report if over.
The field contains titles, I created a new table that has the old titles and
the new titles. When I go to run the update query it is not find and
replacing the information with what I have on the new table.
I am not sure how to proceed from here. Can someone help with the creation
of a find and replace query using a table.

 

[Guest]

Show us the SQL for the Update. Open the query in SQL view and copy and past
it here. Information on primary keys and relationships would be a nice touch
too. Maybe some sample data too.

 

[Guest]

The following is the update query in SQL format below is a few examples of
the old titles to the new titles. This is what is in the table I set up.
Very basic.

UPDATE Salbook INNER JOIN [tbl_Shorten Position Names] ON Salbook.Title =
[tbl_Shorten Position Names].[Old Title] SET Salbook.Title = "Title";

Old title New Title
1 ACCOUNTING SERVICES COORDINATOR ACCTG SERVICE COORDINATOR
2 DIRECTOR TECHNICAL SERVICES DIR TECHNICAL SERVICES
3 MANAGER BUILDINGS AND SERVICES MGR BUILDINGS & SERVICES

 

[John Spencer]

UPDATE Salbook INNER JOIN [tbl_Shorten Position Names]

The following is the update query in SQL format below is a few examples of
the old titles to the new titles. This is what is in the table I set up.
Very basic.

UPDATE Salbook INNER JOIN [tbl_Shorten Position Names] ON Salbook.Title =
[tbl_Shorten Position Names].[Old Title] SET Salbook.Title = "Title";

Old title New Title
1 ACCOUNTING SERVICES COORDINATOR ACCTG SERVICE COORDINATOR
2 DIRECTOR TECHNICAL SERVICES DIR TECHNICAL SERVICES
3 MANAGER BUILDINGS AND SERVICES MGR BUILDINGS & SERVICES

Show us the SQL for the Update. Open the query in SQL view and copy and past
it here. Information on primary keys and relationships would be a nice touch
too. Maybe some sample data too.