crosstab query

[Jayasimha]

Hello,

I have created a crosstab query based on a query.
The base query has a field called description which is actually a text field
and a memo field concatenated.
The length of the concatenated text in the base query is 800 characters.
When I execute the base query all the 800 characters are displayed. When I
execute the crosstab query only 255 characters are displayed.

What could be the problem? Can anyone help me?

Thanks in advance
Jayasimha

 

[Duane Hookom]

Crosstabs use "Group By". I would create the Crosstab without the memo
field. Then create a new query based on the crosstab and add the table with
the memo field.