access query

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

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]")
 
Back
Top