I am having data from a union query truncate when displayed in a
report. All of my data shows in the table, query, and when the query
is exported to MS Word, but not when displaying a report from within
Access (2000).

When I created a union query that didn't have the "Total" button
activated (for groupby, sum, etc.) the query worked great and
transfers the info into a report without truncating any of the data.
Even just the "Totals" button activated but nothing else altered for
calculating is enough to cause the info to truncate. Now I am at a
loss on how to work my way around this issue because I do need
calculations, etc. done in the query without loss of data.

The report I am producing is using data from 4 tables, totalling some
of it, then doing other embedded calculations. I actually have 2
queries, 1 gathering all of the data and summarising initially, and a
second query that draws from the first to do the embedded
calculations. The data is truncating in the first query because of
the "Total" button required for the summarising.

I am considering pulling the memo field out of the first query where
the totals are required and attaching it to the second query where the
Totals button is not needed.

I let you know if it works. If there is a simpler way to do this, or
an MS Access patch, I would like to know, but before I get deluged
with good programming advice, you need to know that I am only an
intermediate programmer! :O)

Thanks to all who answer. Please reply to the list because I searched
the archives looking for this answer and only found many other
inquiries for the problem of truncated memo field data.

Sharon