Union Query

[Don S.]

I have a database for budget purposes in each record has a "Notes" field for
explanation. The data is accepted into the form and table without any
problems but when I pull a report some of the memo items are truncated. I
have the "Notes" Property Item "Can Grow" set to "yes".

I am using a union query to combine certain types of data for consolidated
presentation. I checked the SQL and it truncated the data in the query. How
can I get the entire contents to be shown by the SQL statement and passed on
to the report?

Thanks

 

[Duane Hookom]

You could try use UNION ALL rather than just UNION.

 

[peregenem]

You could try use UNION ALL rather than just UNION.

FWIW using a GROUP BY clause on a MEMO column also causes trunction.