I'm familiar with how to use DGET, where I have a database setup, and I
can retrieve an entry based on matching parameters. However, I can
only get it to return one entry. How would I make it so DGET will
return every entry rather than#NUM! when there is more than 1 matching
entry?--
uscx1
------------------------------------------------------------------------
uscx1's Profile: www.excelforum.com/member.php...oamp;userid=32324
View this thread: www.excelforum.com/showthread...hreadid=520816Instead of DGET, you could use an Advanced Filter to return matching
records. There are instructions in Excel's Help, and he
www.contextures.com/xladvfilter01.html
uscx1 wrote:
gt; I'm familiar with how to use DGET, where I have a database setup, and I
gt; can retrieve an entry based on matching parameters. However, I can
gt; only get it to return one entry. How would I make it so DGET will
gt; return every entry rather than#NUM! when there is more than 1 matching
gt; entry?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
- Oct 05 Fri 2007 20:40
Please Help me With DGET
close
全站熱搜
留言列表
發表留言