hi guys. i'm kinda having a problem.

i have 2 different tables.

one called. Number and the other called NumberSFX.

in the Number table, i have 2 different fields. one called contactnumber and contactnumbersfx.
this means the table looks like:
contactnumber |||||||| contactnumbersfx
S45882236 |||||||||||||||00K



in the NumbersSFX table, i have a single field. its called NEWNUMBERSFX.
it looks like this:
NEWNUMBERSFX
S4522883600K



basically what i want to do is to compare the data between these 2 tables.

Number table has a record of 16k
NumbersSFX table has a record of 68k

i just want to create a query which will enable me to pull out all the data that has the common NEWNUMBERSFX.

this means if the Number table contains S45228836 00K in both the respective fields, and the NumbersSFX table has S4522883600K in its field, the query would call out that data.

Is this possible ?

thanks for your help. god bless.

Resolution here:
http://www.access-programmers.co.uk/forums/showthread.php?t=160748