I'm trying to sort the output of a CHOOSE in descending order. If I specify the field names from the table it sorts ascending, if I use the column numbers in the table I get a bad ORDER BY error, and the same if I specify the number of occurance in the CHOOSE (as if for a SELECT).
The original CHOOSE: (advance apologies: my mail client doesn't like to display the following as plain text). --Select Outreach record for staff productivity CHOOSE vtgoid FROM #VALUES + FOR ((CTXT(dserv)) + ' ' + (CTXT(zipcode)) + ' ' + (CTXT(starttime)) ++ ' to ' + (CTXT(endtime)) + ' ' + (CTXT(MALES + FEMALES))), goid FROM genout + ORDER BY dserv, starttime DESC + AT 20 CENTER TITLE 'Outreach Incidents' + CAPTION 'Select one incident' LINES 12
