Group by and Memo field problem

[Domac]

Hi,

I have a group by query and I want to insert Memo field , I know that i
can't group by Memo field type ,
Is there any alternative solution , set Expresion instead Group by in query
designer????


Please help!
Domagoj

 

[Allen Browne]

Try First instead of Group By in the Total row of your query.

That allows the query to grab the first match it finds rather than have to
compare and group by the memo field. Since you are not asking Access to
aggregate based on the value of the memo, it is free to return the whole
thing.

Other issues are discussed in this article:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

 

[Domac]

Thanks Allen!
Your suggestion solved my problem!