DLookup to retrieve first non-null entry

  • Thread starter Thread starter xp
  • Start date Start date
X

xp

I'm using DLookup in the Control Source of a TextBox and I want it to just
return really any value in a certain column; for speed the first non-null it
finds is fine. How can I do this?

=DLookup("MyColumn", "MyTable", "???")

Thanks.
 
Back
Top