Memo Field Truncated - No DISTINCT or GROUP BY

[Cheryl L.]

I have a very simple Union query that does not use DISTINCT or GROUP BY. It
does use ORDER BY but the fields in that statement are not memo fields. My
memo field is truncated. The query is shown below. Any help would be
appreciated.

SELECT [DateOfMinutes], [TypeOfAction1] AS [TypeOfAction], [Action],
[Superseded?],[DateSuperseded]
FROM [Historical Actions]
WHERE [DateOfMinutes] Is Not Null
UNION SELECT [DateOfMinutes], [TypeOfAction2] AS [TypeOfAction],
[Action],[Superseded?],[DateSuperseded]
FROM [Historical Actions]
WHERE [DateOfMinutes] Is Not Null and [TypeOfAction2] Is Not Null
ORDER BY [TypeOfAction], [DateOfMinutes];

 

[Cheryl L.]

[Action] is the memo field.

 

[Cheryl L.]

Well, I had to go outside the community group to find the answer. I put the
search words in my Yahoo search engine and came up with the answer in about
45 seconds. I needed to change the UNION to UNION ALL and it worked like a
charm.

 

[Allen Browne]

Yep: UNION will do it.

For future reference, Cheryl, see:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Well, I had to go outside the community group to find the answer. I put
the
search words in my Yahoo search engine and came up with the answer in
about
45 seconds. I needed to change the UNION to UNION ALL and it worked like
a
charm.
--
Cheryl L.

I have a very simple Union query that does not use DISTINCT or GROUP BY.
It
does use ORDER BY but the fields in that statement are not memo fields.
My
memo field is truncated. The query is shown below. Any help would be
appreciated.

SELECT [DateOfMinutes], [TypeOfAction1] AS [TypeOfAction], [Action],
[Superseded?],[DateSuperseded]
FROM [Historical Actions]
WHERE [DateOfMinutes] Is Not Null
UNION SELECT [DateOfMinutes], [TypeOfAction2] AS [TypeOfAction],
[Action],[Superseded?],[DateSuperseded]
FROM [Historical Actions]
WHERE [DateOfMinutes] Is Not Null and [TypeOfAction2] Is Not Null
ORDER BY [TypeOfAction], [DateOfMinutes];