Report problem

[cbearden]

IT's the expression. If i remove it...the comments show. But...now I've seen that it cuts part of the comments off. I guess after 255. I originally changed the memComments from text to memo b/c my comments are sometimes over 255. How can I get around this on a report.

 

[Rich]

You cannot use groupby on a memo field in a query, you could get around it by using the Left function

 

[cbearden]

How would I go about doing this?