DLookup

[archiecone]

Can anyone help me out with this function??

From my understanding it will look at values in a field based on criteria that you give it. Does it work with only one record or all the records in the domain?

here is an example of what I have wrote

var3 = DLookup(("cablesize1"), "voltage drop", rs3.Fields("calcamp").Value <= rs3.Fields("amp1").Value)

where cablesize1 is a field in the voltage drop table. And i want the value where amp1 is greater than calcamps.


Can anyone help me out.

Thanks a lot.

[This message has been edited by archiecone (edited 03-12-2001).]

 

[archiecone]

I did not say that I wanted to return more than one value. I said I wanted to return a single value.

 

[archiecone]

Dlookup will return the first value that satisfies the criteria.