query dropping data

[Rose]

I have an ACCESS 2000 database and I have a table with a field setup
as a MEMO. I am trying to run a query and append the MEMO field to
another table - everytime I run the query - it drops data - it doesn't
append the whole memo field - just part of it. The field I am
appending to is also set up as a MEMO.
I have other tables that I am also running the same query on and they
work fine - but this one does not. Any ideas of what I have set up
wrong?

[Rick Brandt]

"Rose" <MA****@AOL.COM> wrote in message
news:e8*************************@posting.google.co m...

I have an ACCESS 2000 database and I have a table with a field setup
as a MEMO. I am trying to run a query and append the MEMO field to
another table - everytime I run the query - it drops data - it doesn't
append the whole memo field - just part of it. The field I am
appending to is also set up as a MEMO.
I have other tables that I am also running the same query on and they
work fine - but this one does not. Any ideas of what I have set up
wrong?

If you have a format property on the Memo field it will truncate at 255
characters. Also if the query has GROUP BY or DISTINCT clause.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com