Number Query

[kappa]

Hi All,
I am trying to perform a query on two tables, with the result being a Dept Name & Dept Number. One table consists of an Index Number & Dept Name, the other table has Dept Number. The index Numbers & Names 14 thru 37 in first table correspond to Dept Numbers 1 thru 24 in second table.
Sorry if this is an easy one..

Thanks in advance

Kappa

 

[Jon K]

SELECT DISTINCT [Table1].[Dept Name], [Table2].[Dept Number]
FROM [Table1], [Table2]
WHERE ([Table1].[Index Number]-13)=[Table2].[Dept Number]
.

 

[kappa]

Thanks Jon K,
Worked like a treat...