Oh, MS Access, why won't you give us the tools we want???
I've devised my own work around for this problem. Like antifasionpimp, I have a seperate table that defines the order I want the column headers to appear in.
instead of a crosstab query, I create a select query that contains all the...