Union Queries

[Guest]

I've created a union query that feeds a report of combined
data. The 2 tables that make up the union query have some
Memo fields. When the report is run the data comes in as
text fields instead of memo fields. The displayed data is
cut off at 255 characters. The fields are set to grow and
shrink.

 

[John Vinson]

I've created a union query that feeds a report of combined
data. The 2 tables that make up the union query have some
Memo fields. When the report is run the data comes in as
text fields instead of memo fields. The displayed data is
cut off at 255 characters. The fields are set to grow and
shrink.

Try using UNION ALL instead of UNION in the query: what's happening is
that Access is truncating the Memo in order to eliminate duplicates.

 

[Guest]

John:

Worked like a champ.

Thanks,

David

-----Original Message-----


Try using UNION ALL instead of UNION in the query: what's happening is
that Access is truncating the Memo in order to eliminate duplicates.


.