locked
How to take a Value from Database equivalent of Given Number... RRS feed

  • Question

  • User-720755217 posted

    Hi


    I am using Ms Access database for Name of Fare Table.

    In Fare Table having follwing Fields and data like..

    --------------------------

    From     To    Fare

    -----------------------

    0            5      110

    6           10     112

    11         15     115

    16         27     150

    28         34      170


    here i m send one vlaue.. I wanna Fare for given equivalent Value..


    for examble I am sending 23 means Query Check '23' is chk in database.. if Existing means find the Fare value and return..... So here return 150..

    because is existing between (16---27)...


    So wat si query i am using to solve above Issue..


    by

    Riyaz


    Monday, October 18, 2010 7:45 AM

Answers