Hello folks,

I have a subform with a control on it that is a combo box, the query that runs it has thre columns in it but you can only see the one as i have the column widths set to 0, the columns are EMPID, EMPLOYEENAME, EMPLOYEESTATUS. it is currently sorting the reocrds according to empid, is there anyway to get it to sort by the second column so the names are in alphebetical order. any help on this would be greatly appreciated.

Branden

Hi,

Try something like this SQL:

SELECT TblEmp.EmployeeID, TblEmp.EmployeeName, TblEmp.EmployeeStatus FROM TblEmp ORDER BY TblEmp.EmployeeName WITH OWNERACCESS OPTION;

The important item is:
ORDER BY TblEmp.EmployeeName

Change the table and field names to match those in your DB, and then paste the SQL into your combo's RowSource - replacing the table SQL or query you have there now.

Your combo should now display ordered by employee name, rather than by ID number

If you wanted to sort descending you would substitute:
ORDER BY TblEmp.EmployeeName DESC

Once you have the combo working the way you want, you can save the rowsource as a query.

Charlie