Union Query and Memo Felds - truncating at 255 characters

[Mike]

To anyone who can help:

I've created a union query, sourcing a table (tbl_stories), using a SELECT
statement to select the desired fields. Some of the sample sql is below.

The Problem: The query result truncates (at 255 characters) two of the
source fields which are memo fields (item_heading and item_synopsis).

The Question: How can I write the sql so as to preserve the field type as
memo, so that the source data is not cut off at 255 characters?

SELECT [COUNTRY], [ITEM_HEADING], [ITEM_SYNOPSIS], "Sect A" as SECTION FROM
tbl_storeis WHERE [checkboxA]=Yes;

UNION select [COUNTRY], [ITEM_HEADING], [ITEM_SYNOPSIS], "Sect B" AS SECTION
FROM tbl_stories WHERE [checkboxB]=Yes;

Thanks in advance for any advice you can give. I can't seem to find a
solution after a good search of Access Help.

Mike

 

[Douglas J. Steele]

I can't remember whether or not this solves the problem, but try replacing
UNION with UNION ALL.

UNION removes duplicates, and in so doing it converts Memos to 255 max
(otherwise the duplicate detection would be too unwieldly). UNION ALL
doesn't remove duplicates, so it should leave the Memo fields intact.