Using Group by:Last in Query

  • Thread starter Thread starter David Tyburski
  • Start date Start date
D

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
 
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
Click to expand...

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!
 
Back
Top