Match up table using only a few charecter?

[bangemd]

I want to create a query that match this two field

first table


second table




the query will combine 2 table into 1 that have partner in the format of the second table 3 character long and name, extension, transaction, and data.

Thanks a millions

[RuralGuy]

The Partner field is just Right([Partner],3) is that helps.

[bangemd]

Thank you for the quick reply, what if the 3 partner code is not locate at the right, but sometime on the left and sometime in the center. Is there a way to generate a query for that.

Thanks

[RuralGuy]

You have not supplied enough information to answer the question with any accuracy. If you do not know where in the string the Partner code will appear or what the Partner code looks like, then how do you propose locating the string?

[bangemd]

what I mean is the three letter partner code is mix in the text is there away that we can match the these 2 table up. since they both have the 3 letter code one just happen to be with other text in between.

thank you ruralguy

[RuralGuy]

InStr() can help locate the three letter code but might be prone to errors if there is a duplicate because of the additional letters in the one field. How many records are we dealing with in the two tables? How often does this need to happen? Does either table have a PrimaryKey?