You can't use a pass-through query or a non-fixed-column crosstab quer 1

[fredka]

I am getting the above error. I have a crosstab query that uses a "year" field as the column and the month field as a row. I cannot assign heading to the year as these years will change (the report is a 4 year comparison report.

I am using unbound fields on the report that are assigned at runtime. The problem is that I want to include the repor and a chart (therefore, I need to attach both to a main report) access will not let me do this (subject line error)

Is there anything else I can do? thanks!!!

 

[dhookom]

Use relative years as column headings as described in the article faq703-5466.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fredka]

thats exactly what I am looking for - as always thanks!!!!