Search help

[lead 27]

Hi

I have a table with a list of sizes in. The fields are min height, max height, min chest, max chest, and size. I am wanting to somehow make a way of imputting a height and a chest size and getting the corresponding size, so it will need to search greater than the min and smaller than the max of the height and chest.

I have tried everything that I can think of with queries and a command button with code but still cant quite figure it out

can anyone help??

Thank you

 

[Len Boorman]

How about using two queries

Input Chest and height

First query searches for on Chest size and returns sizes and heights and then query the first query with height... leaving you with Size

L

 

[Bilbo_Baggins_Esq]

Did you look at that sample database I sent you with regard to the "kit" you were asking about last week?

This basically (exactly) the same thing...