DLookup

[eacollie]

If there is more than one value when using DLookup(), is there a way to concatenate those?
Thanks!

 

[Cronk]

There can be many values in the criteria but only one value returned which is the contents of the field selected.

Alternatively, you could base the search on a query and concatenate values there. For example,
Dlookup("Name", "tblCustomers","CustomerID=20)
where Name is concatenating the first and family names.

 

[Galaxiom]

There can be many values in the criteria but only one value returned which is the contents of the field selected.

The first argument is not a fieldname but an expression.

Continuing with Cronk's example:

DLookup("[FirstName] & ' ' & [FamilyName]", "tblCustomers","CustomerID=20")