DLookupPlus will allow you to return a sorted list of items from any table or query, based on your criteria and specified delimiter.

Why DlookupPlus?

Let's say you have a table of sales reps, and a table of states they cover:

SalesRepT

StateT

Now you could make a query that shows all of the sales reps and the states the represent like this:

Usage

In your query, the call to DLookupPlus would look like this:

StatesCovered: DLookupPlus("State","StateT","SalesRepID=" & SalesRepID, "State")

Class

Design of this function is covered in Access Developer 17, Lesson 3.

Code Only

You can get the source code for this function as a Gold or Platinum Member.

• Link to Source Code for Access VBA
• Link to Source Code for ASP (VBScript)

If you have any questions, post them below.