Vlookup

[thedeadzeds]

Guys,

I want to be able to create a vlookup in access. I have 2 tables, table1 and table 2 which contain an ID and numbers. I want to run a query to only bring up the numbers which are in both tables only.

Is this possible. Please see attachment.

Regards

 

[JHB]

The below should do it, paste it into a new query.

SELECT Table1.ID, Table1.Number
FROM Table1 INNER JOIN [Table 2] ON Table1.Number = [Table 2].Number
ORDER BY Table1.ID;