Dlookup to return 2nd/3rd/4th value etc

[JamesN]

Hi,

I have a table which contains fields agent and month no, also Call ID.

=DLookUp("[CallID]","OperationDataWarehouse","[Agent]='" & [Agent] & "' AND [MonthNo]='" & [Month2] & "'")

I am using the above dlookup to return the Call ID for the agent and month no selected in a form.

Is is possible to get a dlookup to return other values outside of the 1st match? I need to be able to return the 1st Call ID but also 2nd/3rd/4th etc.

Is this possible?

 

[Ranman256]

If you need to return many values, the use a query.
If you need to show them all, either use the query data sheet,
Or a list box.

NOT a dozen dlookups.