Crosstab Limitation

[mf28446]

I want to create a crosstab query BUT my column headers are longer then 64 characters (don't ask) and Access seems to limit me to 64 characters. Anyone have a work around? Thanks.

[ranman256]

Nobody needs that many chars for a title (hence the limit). Build a select query where all titles are normal (brief).
Then crosstab THAT query.

[mf28446]

Nice try but my Boss has another opinion about title length. Title need to include date, name of transaction, firm, and law firm. Need to sort by date then trasaction name then firm.

[lfpm062010]

Can you swap the column and row heading? It seems that column heading only display up to 64 characters (even if your actual text are longer than 64). It does not seem that row heading have that restriction (I have it display up to 100 characters and it seems to be ok, I don't what the upper limit is).

[mf28446]

Can try this on but he is used to other format. Thanks.

[lfpm062010]

The only other suggestion (not tested).

Instead of using Access Crosstab, try using the Excel pivot table. Good luck.