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!

 

[Jamie Collins]

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

I think your article, entitled 'Truncation of Memo fields', contains an
inaccuracy:

"Uniqueness... The comparison causes truncation...[work around] remove
the DISTINCT key word [sic] in SQL View."

I cannot reproduce truncation with the DISTINCT keyword in Jet SQL.
Instead, I get an error, 'The field is too small to accept the amount
of data you attempted to add. Try inserting or pasting less data.'

Jamie.

--