Using Group by:Last in Query

[David Tyburski]

When I use Groupby: Last in a query in a memo field, I only got 255 char
even though in the table it has 300-400 chars.
Thanks

 

[John Vinson]

When I use Groupby: Last in a query in a memo field, I only got 255 char
even though in the table it has 300-400 chars.
Thanks

Try First(). You can't Group By a memo; and Last is pretty near
useless, since it gives the last record in disk storage order.

You might need to use a query based on a query - save the totals query
which contains the Primary Key of the desired records, and join this
to the table to pick up the Memo field. Memos and totals just don't
mix!