access query

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
 
K

Ken Snell \(MVP\)

You could use a DLookup function:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top