Solved: Query truncated field

[ALe]

Hi everybody,

My query concatenates data from 3 text fields of a table in one field. The resulting string (very long) is truncated.

How can avoid this? Is there a way to define the resulting field as memo and not as text (max 255 ch.)?

Thanks in advance

[Oorang]

Yep. But I need to know more:
What kind of query? (Please post the SQL.)
How are you using it?

[ALe]

Yep. But I need to know more:
What kind of query? (Please post the SQL.)
How are you using it?

Thank you Aaron. I found the solution. The Sql is very simple (just Select and group by).

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

[Oorang]

Heh. Much simpler than what I was thinking