I am having trouble trying to get my head around the dlookup function and was hoping someone could explain it to me in laymans terms. I understand the basics, but what I am trying to do is display a field based on TWO variables matching.
Details are :
Usage Info form (tariff type, usage)
savings table (tariff type, start usage, end usage, savings) - where start usage and end usage are numberic fields and the usage from the usage info table will be between these two figures.
I want to display the savings field from the savings table on the usage info form.
Can anyone help me out, this needs to be finshed in the next few hours. Thanks in advance!

How about...

Me.Savings = DLookUp("[savings]", "Savings Table", _
"[start usage] <= " & Me.Usage & " And [end usage] >= " & Me.Usage)

Where Me.Savings and Me.Usage are the textboxes in the form.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Greg, I'll give this a shot.