I am trying to generate a spreadsheet style report. I can active this if I know the column heading but I what the column headings to come from the data. I have partially made this happen with a report based on a crosstab query but need more column headings than the one available to me on the crosstab. Is there anyway of achieving this without using code?

What do you mena by "need more column headings"?

The is limit to the columns is a cross tab query is very large. How many do you need?

There is probably a better way to do what I want but I need one more column heading.