In my Access database I have a row in my table that is linked to another ID in a different table. I have that row display a combo of the user name. It is setup as follows:
SELECT Employees.EmployeeID, [LastName] & ", " & [FirstName] AS Expr1
FROM Employees
ORDER BY [LastName] & ", " & [FirstName];
The statement above displays the Employees LastName, FirstName.
However, it doesn't seem like I can get that to work in ASPRunner. When I view it in Internet Explorer it does not show the Employee Name, it shows just the ID number. Is there a way that I can get it show the names?
