I run a crosstab query. I sort on the sum column. Works. I check to design view to make the sort permanant. Try to run. 'Cannot have order by on aggregate clause'. Crud. Go back to datasheet view. Sheet is not sorted. Sort on the sum column. 'Cannot use the crosstab of a sum column as a subquery'. -.-*
The process is repeatable, even if I only view the design view and change nothing. What's going on?
The process is repeatable, even if I only view the design view and change nothing. What's going on?
