How can I get DGET to return all records that meet the criteria?
I was able to get this function to work, but it only returns 1 record when
there can be many. If my criteria so happens to be a unique record, it
works. However, if I it has muliple records that match, i get a #NUM! Error.
Help will be greatly appreciated.
John C[_2_]
How can I get DGET to return all records that meet the criteria?
The inherent function of DGET is that if multiple records meet the criteria,
you get the error. Do a search In: Excel Worksheet Functions. Search for: get
multiple records. There is a thread titled Using DGET to extract multiple
records that you may find useful. (Note: They didn't use DGET).
--
John C
"Eddie A" wrote:
I was able to get this function to work, but it only returns 1 record when
there can be many. If my criteria so happens to be a unique record, it
works. However, if I it has muliple records that match, i get a #NUM! Error.
Help will be greatly appreciated.
