If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
access query
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 |
Thread Tools | |
Display Modes | |
|
|