Using crosstab queries as the source for reports

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have two reports both of which were made using crosstab
queries. When I try to combine the 2 one with the first
one, I get an error message telling me that I can't use a
pass-through query or a non-fixed column crosstab query as
a record source for a subform or subreport.

Can anyone tell me how to combine these two reports?

Thanks,
Karen
 
To turn it into a "fixed column crosstab":

1. Open the crosstab query in design view.

2. From the View menu, choose Properties. (Make sure you are viewing the
properties of the query, not those of a field.)

3. In the Column Heads property, list all the possible column headings,
e.g.:
"Fred"; "Betty"; "Wilma"; "Barney"
 
I'm not sure what you mean by "combine these two reports". My general advice
would be to update the Column Headings property of crosstab queries.
 
That was it! I added the column headings to the query that was the source for the subreport. Thanks to both of you
Karen
 
Back
Top