>I have a table that I index on a department identifier. Then department id has several records that are dated. How do I sort the indexed table by dates wiyhin that index? Thanks for the help.
If the Department ID is a character string, try DeptID + DTOS(dDate)