devxlogo

Display Two Fields

Display Two Fields

Let’s say you want to bind your listbox to a recordset, but you also want to display two fields concatenated together, such as “Jones, Barbara.” You can do this by using a calculated expression in the SQL statement of the query:

 SELECT PersonID, LastName, FirstName, LastName + ', ' _	+ FirstName AS FullName FROM Person ORDER BY _	LastName, FirstName
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist