Join table with non matching Auto Number

[vksjndl]

Hi Team,

Please help!!

Scenario: I have two table (Table1 and Table2) as below.

Table1:
ID Name
2 John
3 Tom
5 Kevin

Table2:
ID1 Code
1 AA
4 BB

I need a result with all the Table1 data and one more column of Code where ID.Table1 is less than ID1.Table2

Expected results:

ID Name Code
2 John AA
3 Tom AA
5 Kevin BB

Thanks in advance.

VJ

 

[AlexandraT]

Not quite getting it. How is ID 2, name John assigned code AA? According to Table2, AA is the code for ID 1 and not 2. Can you explain further?
Alex

 

[vksjndl]

Hi Alex,

Sure, let me explain you the complete scenario.

I have text file which has data is below format.

Code AA
John
Tom
Code BB
Kevin

then I import the text file in MS Access table with Auto Number and then I create query to seprate code with Autonubers. Now I want those Code next to Name column.

Hope it helps.

Thanks,

VJ

 

[james_lankford]

"where ID.Table1 is less than ID1.Table2"


the ID for John in Table1 is 2


the ID1 for AA in Table2 is 1


2 is not less than 1


so how can John be associated with AA ?

 

[vksjndl]

Hi James,

You are right, it should be greater than not less than. Please read my second comment, I explaind the complete scenario and desire result.

Thanks for your reply.

VJ