Getting cross-tab querie data into a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cross-tab querie that is working fine. The possible row headings
are 1-10. Of course, if in the data there is no data for, say the row
labeled "3", there simply will not be a "3" row in the output.
However, I'd like to get the data into a report that has ALL the possible
row headings listed. Like this:
Column 1 Column 2 Column 3
1
2
3
4
5
6
7
8
9
10

I fear I have massacred the explanation, but how do I do that?

Thanks in advance.

Jerry
 
Combine your crosstab query with a table/query that contains records with
values 1-10. Set the JOIN to include all records from the table with 1-10.
 
I've been sitting here staring at your response, Duane, and I guess I'm just
too dumb on this issue to figure out what to do. I'm not sure how to
"combine" a query with a table/query.

Sounds like I should create a new table that somewhat mirrors the existing
query, in that the fields would be RowName, Column1Name, Column2Name,
Column3Name, etc. and only have 10 records in the table (RowName values of 1
to 10).

Am I anywhere near being close?

How, then, would I combine the two?

Jerry
 
Back
Top