DLookup to retrieve first non-null entry

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access ACCESS DLOOKUP INVALID USE OF NULL 0
Checking if data exists another table and, if yes, extracting a value 0
dlookup based on first digits of a field 3
DLookup stops working in SubReport - why? 0
DLookup question.... 2
Set Textbox value by selecting item from combobox but it must beeditable 2
Dlookup only returning the first record 6
dlookup problem 9

Top