I'm attempting to create a union query in MS Access where one of the fields in both selects is a memo field. The query functions properly except for the fact that the data in the memo field is truncated at 256 characters in the result. Documentation doesn't seem to warn against this limitation. What am I doing wrong? Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Union query with memo fields in MS Access
- Thread starter psryan
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
