I have a listbox that I've populaed using the row source

SELECT DISTINCTROW [FirstName] & " " & [LastName] AS Name, Personnel.Email,
Personnel.[Voice Part], Personnel.LastName, Personnel.FirstName
FROM Personnel
WHERE (((Personnel.Email) Is Not Null) AND ((Personnel.Status)="Active"))
ORDER BY Personnel.LastName, Personnel.FirstName;

I have three columns and I would like to be able to sort by the columns. In
other words, sort by Name, then later sort by Email or [Voice Part]. I've
seen a bunch of examples and tried them but nothing seems to work.

Bruce