Dblookup Multiple Values

Hi,

I am using dblookup to get values from an ODBC database. The function works, but it returns mutiples values for the computed field. Is there a way to add additional criteria to filter further the multiple values that are returned so that I can get a single value?

Rika

Subject: dblookup Multiple Values

@Dblookup will only allow you to test on one key column. Some random thoughts:

  1. If values are identical then use the Distinct option to remove duplicates.

  2. If you only need the first / last then use @subset to filter these.

  3. Try creating a “view” in the ODBC database that concatenates the multiple key columns from the source table in to a single column that you can dblookup against to get a single value.

  4. Look at @dbcommand to specify your own Select statement that will return a single value.

HTH - Rufus.