Weird Crosstab results

[SteveApa]

Hi All.



Getting a weird result from a crosstab query. If I do a select query, I see "Comments" field fine. But, in a crosstab I see the comments converted to characters like... I did a length check in a select query and I am not over 255. 


Thanks.
Steve

[John_G]

If the comment field is defined as a memo type you will get results like that - it doesn't matter how much text is in the comment.

try using left(comments,255).

[SteveApa]

Thanks. I checked the linked table and it is of type Long Text. It is strange that all select queries show it properly, but crosstab does not. Thanks for the help. left 254 fixed it.