Hi. Access does not allow more than 255 columns in any query/table.
Even if it did, consider what it would mean to users/you to have so many columns of data to scroll through. Complexity does not aid understanding.
By the way, Excel has just the same limit on the maximum number of columns...
-Stewart
Can the max limit of crosstab quer be increse from 255