selective update

[Rockape]

Hi all,

Grateful for some assistance or pointers.

I have three tables:

Table 1 = Master table with a field with old data that requires to be changed

Table 2 = table which has the field with the old data and a field with the new data to be swapped.

Table 3 = a table similar to table 2 with records of data that should not be updated

Is there a vba way of deselecting those records in table 2 as stated in table 3 in order to only update Table 1 with only those that should be updated.

Am I making any sense?

Grateful for comments

 

[Rockape]

Hi all,

Should i be more specific..

Hi all,

Grateful for some assistance or pointers.

I have three tables:

Table 1 = Master table with a field with old data that requires to be changed

Table 2 = table which has the field with the old data and a field with the new data to be swapped.

Table 3 = a table similar to table 2 with records of data that should not be updated

Is there a vba way of deselecting those records in table 2 as stated in table 3 in order to only update Table 1 with only those that should be updated.

Am I making any sense?

Grateful for comments

 

[Rabbie]

It should be possible but it would be helpful if you could post some sample records for each table so we can see exactly what you are trying to do.

 

[Rockape]

hi Rabbie,

Table 1 = Name, Telephone No
ANother, 12345
BNother, 12345
CNother, 23456

Table 2 = Name, Telephone No, New Telephone No
In this case I could have three records which look like:
ANother, 12345,11111
BNother, 12345,11111
CNother, 23456,22222

I have managed with some previous help using an update query to reset Telephone No with the New Telephone No

However I'm now being told not to update CNother in Table 1 with the New Telephone No using
Table 3 = Name, Telephone No, New Telephone No
eg. CNother, 23456,22222

Hope this is clearer

Thanks again