Thank you Aaron. I found the solution. The Sql is very simple (just Select and group by).Yep. But I need to know more:
What kind of query? (Please post the SQL.)
How are you using it?
SOLUTION: when you use "group by" on a memo field this is truncated by access to do the aggregation. The solution is to change the aggregation from "Group by" to "First".
Bye