crosstab query

[Jayasimha]

Thanks, now the query works but when I generate a report based on this query
the text is once again getting truncated to 255 characters.
Any idea what could be the problem.

Thanks in advance,
Jayasimha.
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.

 

[Duane Hookom]

I assume you now see all the data in the report's record source query. Make
sure:
1) don't sort on the memo field
2) no format property set on the text box
3) the text box can grow
4) the section can grow