Memo fields truncated when using SELECT DISTINCT

[skinnybloke]

Hi - I have a problem with a memo field being truncated to about 255
characters when running a Access 2002 query.

This only seems to happen if I use SELECT DISTINCT. It works ok using
SELECT by itself.

does anyone know why this happens and how to stop it?

[Allen Browne]

Re: Memo fields truncated when using SELECT DISTINCT

Yes, your post from 3 minutes ago did show up.

[skinnybloke]

Re: Memo fields truncated when using SELECT DISTINCT

sorry - slip of the fingers

On Thu, 29 Apr 2004 23:13:37 +0800, "Allen Browne"
<AllenBrowne@Se eSig.Invalid> wrote:
[color=blue]
>Yes, your post from 3 minutes ago did show up.
>[/color]