>I have a temporary table with user names and dates. User names are repeated with many dates for each user name. I need to print this table sorted by user name (ascending) with dates for each user (descending). I normally create another field and subtract the date fields from today's date to get a number that when sorted (ascending) will print the dates in descending order. Is there a simpler way to mix ascending and descending together?
You can do it with SQL statement
sele trandate ,checkamt ,readoper from chek order by trandate asc , checkamt desc