posted 18 years ago
You can specify: ORDER BY Employee Desc
This will take the results and display them based upon the Employee column in descending order, basically showing it Employee2, Employee1. You can also play with the GROUP BY function to group results together, such as all employees in a particular work center. You can even use the ORDER BY with the GROUP BY to make the results return exactly like you want them to.
Bryan Scarbrough<br /> <br />Consistency is the last resort of the unimaginative!