Number between numbers

[BradM]

Hello,

I have two tables: one with a item name and two numbers x,y and the other table has a category name and x_high, x_Low, Y_high & Y_low. What I am trying to do is see what category each number falls into.

What I want to get in the end is which category each name belongs in based on if the numbers are between the high and low numbers in the category table.

I know I will have to use IIF statements and it will have to be in code. I thought about doing it in excel but It could be a coule thousand names so I didn't want to transfer back and forth.

Any help is appreciated.

Brad

 

[CT Witter]

Modify this to suit:

SELECT Table2.Name, Table3.Category, Table2.X, Table2.Y
FROM Table2, Table3
WHERE (((Table2.X) Between [Table3].[LowX] And [Table3].[HiX]) AND ((Table2.Y) Between [Table3].[LowY] And [Table3].[HiY]));

where Table2= Item Name Table
Table3 = Category Table

HTH,
CT

 

[BradM]

that is exactly what I needed.

Thanks
Brad