access query

I was working on this before but I lost track of it. On a form I would
like to return a value from a table. The table has 3 columns min amt and
maximum amt and a number that applies if this amount on the form meets the
criteria...between the minimum and maximum amount. I would like to do it
onthe form, but if not, then in a query,



Thanks.


ps dont know SQL, has to be very basic

You could use a DLookup function:

DLookup("FieldBeingReturned", "NameOfTable", [NameOfControlOnFormWithValue]
& " Between [MinAmt] And [MaxAmt]")

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Christina" wrote in message
...
I was working on this before but I lost track of it. On a form I would
like to return a value from a table. The table has 3 columns min amt and
maximum amt and a number that applies if this amount on the form meets the
criteria...between the minimum and maximum amount. I would like to do it
onthe form, but if not, then in a query,



Thanks.


ps dont know SQL, has to be very basic