>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?
For reporting purposes, forget about the index. SELECT is much easier and more flexible.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)