Union Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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.
 
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.


.
Click to expand...
 
Back
Top