G
Guest
I have two tables, one contains information on properties and one of the
fields within this table is "Band" this contains a numeric value. The second
table contains a "minimumvalue", "maximiumvalue" and "equvilantband". I am
trying to build a query that will take the value of band from the properties
table and determine what the "equivilant band" is by seeing which category of
"minimum/maximumvalue" it falls in eg say one of the rows from the second
table is as follows
minimumvalue maximumvalue equivilantband
0 100 A
and from the properties table the "band" value is 50 then I want the query
to return the value "A"
Thanks for your help
fields within this table is "Band" this contains a numeric value. The second
table contains a "minimumvalue", "maximiumvalue" and "equvilantband". I am
trying to build a query that will take the value of band from the properties
table and determine what the "equivilant band" is by seeing which category of
"minimum/maximumvalue" it falls in eg say one of the rows from the second
table is as follows
minimumvalue maximumvalue equivilantband
0 100 A
and from the properties table the "band" value is 50 then I want the query
to return the value "A"
Thanks for your help