Record Match Query

[manu]

Here's what I have:

1. Field1 with Names
2. Field2 with their IDs
3. Field3 with another list of names where some values might be equal to or similar to Field1
4. Would like to populate Field4 with respective IDs from Field2 where Access deems either:
Field1 = Field3
OR
Field1 Like Field3

Steps already taken:

1. Attempted an Update query where Field4 should be updated with respective ID from Field2 if Field1=Field3 or Field1likeField3

2. Access goes into a "Not Responding" mode on running this query

3. Recordcount Field1 = 84000
Recordcount Field3 = 72000

All help is much appreciated..

Manu

[This message has been edited by manu (edited 09-28-2001).]

 

[Liv Manto]

Since you have different recordcounts for Field 1, Field 3, does this mean you have two tables linked by Field 1?



[This message has been edited by Liv Manto (edited 09-28-2001).]

 

[manu]

No, there are no links.

This table was created solely to answer the Question "Identify common records between Field1 & Field3 and populate the respective ID for each common record in Field4"

I hope this answers what you were looking for.

Thanks for your time and help

Manu

 

[Rich]

Is this an exercise, project?

 

[manu]

Hi Rich

IDs populated in Field4 shall become the respective ID field for records of Field3 (which are currently orphan) similar to what Field2 is to Field1

This shall assist me in appending response codes in a seperate Marketing Database to Field3.

This is a genuine challenge that I am seeking some assistance to resolve.

Hope this puts things in perspective

Regards

Manu