-
Finding a value between min max
I am having problems to find a value
with the following table in Access 200
id_Price PriceMin PriceMax
1 10 20
2 21 34
3 34,4 40,22
How can i find the id_Price for 21,44 ? (in that case it must return 2)
thank you
-
Select id_price From PriceTable Where 21,44 between PriceMin AND PriceMax
-
that was so simple :-)
it works !
thanks a ton
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|