I've just come across the darndest thing, and it has me scratching my head. I'm using Access 2002 but this is an Access 2000 file format.
I exported the results of my crosstab query to a spreadsheet, and some (not many) of the figures did not export to the correct columns. I rectified it by opening the query then copying and pasting the results into a spreadsheet, but I was just wondering if this is a recognized problem. If not, BEWARE!!!!!!!