Update Query

[peciam]

Hello to all,

I have two tables. I want to update a field based on the name. Problem is the name in table 1 and the name in table two are not exact matches.

Example:

Table 1 = Name field= Berlin Teacher Assoc., table 2 Name Field = Berlin TA. I want to take the local number from table 1 and update table 2 local number when the name field contains all or part of the name field.

Any help much appreciated.

TC

 

[ZOR]

Problem will be matching if they are so different to each other. Are the tables related to each other (linked) ?

 

[peciam]

Hi,

Thanks for respounding. No the tables are not linked/related to each other.

TC

 

[ZOR]

Thought someone else might have come in, although with no relationship between tables, and data so different to compare its no wonder.
Its very bad practice to have the same data in more than one table.

If there are not many records I would start with doing selective queries on each table, and get a DISTINCT list of both tables fields in ascending order, and then look at whats to be done. There is no magic update query that I can think of that will help. I would think about future table design and links, maybe play around to create a new table from what you have before doing a failed update query to have to undo.

 

[dhookom]

Actually peciam has started another thread with the same question so this thread should probably be terminated.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]