close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()