Crosstab Report Issue

[Ecohouse]

I'm using Access 2002. I'm creating a report dynamically using a
crosstab query. I found the code for this on the Microsoft site.

I noticed that the report doesn't go past six pages. How can I make
the report go past six pages?

Also is there a way to sort the total column in descending order?

Thanks in advance for the help.

[Gary Floam]

Re: Crosstab Report Issue

Ecohouse,

I think you are asking about the width of the report, that the cross-tabs can
only fill up 6 pages across. There is a limit of 255 items in a query, even a
cross-tab query. If you really need more (and the result will be hard to
read), you will have to divide the query into several queries and produce a
cross-tab for each. You will have to make sure that all the all of the rows
will appear in every report. You can do that by having a sum item in each
query, even if you don't print it on the report.

You should be able to sort the total column in the Order property of the
report, not of the query.

Hope this helps,

Gary

"Ecohouse" <ecovindaloo@ya hoo.comwrote in message
news:1182516118 .467988.303610@ p77g2000hsh.goo glegroups.com.. .

I'm using Access 2002. I'm creating a report dynamically using a
crosstab query. I found the code for this on the Microsoft site.
>
I noticed that the report doesn't go past six pages. How can I make
the report go past six pages?
>
Also is there a way to sort the total column in descending order?
>
Thanks in advance for the help.
>

[Ecohouse]

Re: Crosstab Report Issue

Gary,

Thanks for the quick response. I'm not talking about the width of the
report. I'm referring to the actual length of the report.

The crosstab query I'm using only has 332 records in it. The crosstab
report I'm using only has five fields. So I don't think the size is
the issue. I'm just wondering if it is something in the code. But I
can't see anything in the code why it's stopping at page six.

Any other ideas?

On Jun 22, 9:02 am, "Gary Floam" <f...@comcast.n etwrote:

Ecohouse,
>
I think you are asking about the width of the report, that the cross-tabs can
only fill up 6 pages across. There is a limit of 255 items in a query, even a
cross-tab query. If you really need more (and the result will be hard to
read), you will have to divide the query into several queries and produce a
cross-tab for each. You will have to make sure that all the all of the rows
will appear in every report. You can do that by having a sum item in each
query, even if you don't print it on the report.
>
You should be able to sort the total column in the Order property of the
report, not of the query.
>
Hope this helps,
>
Gary
>
"Ecohouse" <ecovinda...@ya hoo.comwrote in message
>
news:1182516118 .467988.303610@ p77g2000hsh.goo glegroups.com.. .
>
>
>

I'm using Access 2002. I'm creating a report dynamically using a
crosstab query. I found the code for this on the Microsoft site.

>

I noticed that the report doesn't go past six pages. How can I make
the report go past six pages?

>

Also is there a way to sort the total column in descending order?

>

Thanks in advance for the help.- Hide quoted text -

>
- Show quoted text -