Dlookup last row from multiple

[subtilty]

Hi All,

I have the following dloookup:

txtcustomeremail = DLookup("custemail", "calldata", "Reg=txtbocid")

And it works fine and brings back a value, however it brings back from the first row. I need it to bring back the matched email address from the latest row with the matching reg. Is this possible?

Many Thanks,
James

 

[pr2-eugin]

Hello James, You might want to use ELookUp(), a method implemented by Allen Browne that will allow you to sort the data, thus giving you the Last value for the matched Reg..

Hope this helps !

 

[subtilty]

Looks perfect. Thanks!

 

[pr2-eugin]

Glad to help..