"david epsom dot com dot au" wrote
Just checked A2K with JET 4 SR7,
and it still has the bug that SOME-
TIMES returns garbage records if
you group by a memo field.
Unless I misremember, you can't reliably use a memo field in that manner,
nor in some other ways, so I'd consider myself "lucky" the times that it
doesn't return garbage records. As I've never found a need to use a Memo in
this manner, I can't say if perhaps there have been changes in this area --
but I'm not aware of any.
Memo fields are for holding, er, "memo" type data (voluminous text). If the
first 255 characters of the Memo field will be enough for ordering, create a
calculated field in the query to hold that much of the memo, and group by
that.
Larry Linson
Microsoft Access MVP
