M
mattc66 via AccessMonster.com
Hi All,
I need to build a query that will display the data bases on the range of a 2
cells.
We build heaters and CuFt Size of your room determines that Heater KW you
need.
So I have a table with the CuFt Min and CuFt Max and the corrisponding Heater
KW.
The user will enter the Room CuFt in a form and I want to display the Heater
KW(s) that would work for the room size. So if the user entered 125 the
result would be 3.0 KW and 4.5 KW.
How would I write my query so that it can look up this info.
Room Size HEATER
CuFt Min CuFt Max KW
45 100 2.1
70 150 3.0
100 210 4.5
175 310 6.0
250 425 8.0
390 600 10.5
510 740 12.0
630 950 14.4
Thanks
Matt
I need to build a query that will display the data bases on the range of a 2
cells.
We build heaters and CuFt Size of your room determines that Heater KW you
need.
So I have a table with the CuFt Min and CuFt Max and the corrisponding Heater
KW.
The user will enter the Room CuFt in a form and I want to display the Heater
KW(s) that would work for the room size. So if the user entered 125 the
result would be 3.0 KW and 4.5 KW.
How would I write my query so that it can look up this info.
Room Size HEATER
CuFt Min CuFt Max KW
45 100 2.1
70 150 3.0
100 210 4.5
175 310 6.0
250 425 8.0
390 600 10.5
510 740 12.0
630 950 14.4
Thanks
Matt