Results 1 to 3 of 3

Thread: Finding a value between min max

  1. #1
    Join Date
    Jul 2004
    Posts
    106

    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

  2. #2
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    Select id_price From PriceTable Where 21,44 between PriceMin AND PriceMax

  3. #3
    Join Date
    Jul 2004
    Posts
    106
    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
  •