append memo field via append query

[Rose]

I have an access 2000 database. In it I have a table OPEN Items which
has a field Issue that is setup as a MEMO field. I am trying to
append information from another table with the same setup, but it does
not bring in all of my memo field - it cuts off the data. I have
other queries setup to do the same thing from different tables and
they work fine. I cannot see anything different in my tables or
queries. Anyone have any ideas of what I might be doing wrong.

[Allen Browne]

The memo will be truncated if you use a source query that involves any
aggregation (e.g. a GROUP BY clause or DISTINCT predicate in a SQL
statement), or formatting (e.g. UCase(), or something in the Format property
of the memo field in the table or the Format property of the text box on a
form).

In a Totals query, you may be able to avoid the issue by using First(MyMemo)
instead of grouping by the memo field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

I have an access 2000 database. In it I have a table OPEN Items which
has a field Issue that is setup as a MEMO field. I am trying to
append information from another table with the same setup, but it does
not bring in all of my memo field - it cuts off the data. I have
other queries setup to do the same thing from different tables and
they work fine. I cannot see anything different in my tables or
queries. Anyone have any ideas of what I might be doing wrong.