I have created a crosstab query with columns using a date field. I have selected Date as the grouping. When opening the query it is sorted alpha numeric instead of by date. The data I will be looking at is dynamic so setting fixed columns is not an attractive solution.
TIA
Kent
TIA
Kent