report based on crosstab query

J

Jayasimha

Hello,

I am using MS access 97.
I have created a crosstab query. One field in the crosstab query has around
800 charaters. The query results show all the text for all the fields.
When I create a report (dynamic column headings) based on this crosstab
query the text is getting truncated to 255 characters only.
The query is not sorted on the memo field, no format options have been set
to this field. I am not able to figure out the problem.
Can anybody help me with this problem?

Thanks in advance,
Jayasimha.
 
D

Duane Hookom

Crosstab queries use Group By or other aggregates on all fields/columns. You
would find the same results in a simple group by query. This will truncate
memo fields to 255 characters or less.

You may be able to build your crosstab first and then add your memo field
into a new query based on your crosstab query and other table.
 
Top