i am waiting
No matter how long you wait or how much you want, DLookUp will never return more than one value.
That is: the value in the field specified in the first argument, from the table or query specified in the second argument and the first record that matches the third argument.
It cannot return all the values or all the records.
If you want all the records that match your criteria, you need to use a query or open the recordset in VBA.
Can you provide an example of what you are actually trying to achieve?
David
The DLookup function only returns one value.
However, the DLookup function can return more than one field from the same record.
DLookUp("field1&field2","table1","table1.somefield=1")
DLookUp("field1*field2","table1","table1.somefield=1")
Sub Test()
Dim vntResult As Variant
vntResult = DLookup("[Systolic] & '|' & [Diastolic] & '|' & [Pulse]", "tblPressures", "[SampledAt] = #02/08/2009 8:36:52 AM#")
MsgBox "Systolic = " & Split(vntResult, "|")(0) & vbNewLine & _
"Diastolic = " & Split(vntResult, "|")(1) & vbNewLine & _
"Pulse = " & Split(vntResult, "|")(2)
End Sub