var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem with sorting in Crosstab Qry
I have a crosstab query that is using a date field for the column heading. I need the columns to sort in ascending order, however, this isn't working properly.
For example, the column 01/01/2004 is before the column 04/30/2003
Re: Problem with sorting in Crosstab Qry
What is the date format/date separator on your machine? One solution is to use the Format function to display dates as strings in the yyyy/mm/dd format:
Make sure you use 4-digit years in case you have date prior to 2000.