Memo Field data is being truncated in mail merge

[FA]

Hi friends i have been having this problem and just can not find a way
to resolve it. Below is my query and the results of this query get dump
into a table called TEMPS. Then i am doing a mail merge with the table
TEMPS with the following code;
MergeNoPrompts "FindingReport", "C:\Word", True, "FindingReport", "
select * from TEMPS"
When the word document opens, i see every result except the data is
being truncated for the field type memo.

Any clue why its doing it??


SELECT dbo_SYS_INFO.SYS_NME, dbo_SYS_INFO.SYS_URL,
dbo_SYS_INFO.TEST_BEGIN_DATE, dbo_SYS_INFO.TEST_END_DATE,
dbo_FINDG.FINDG_STAT_DATE, dbo_FINDG_STAT.FINDG_STAT,
First(dbo_FINDG.SMRY) AS FirstOfSMRY, First(dbo_FINDG.RSK_DESC) AS
FirstOfRSK_DESC, First(dbo_FINDG.RCMN) AS FirstOfRCMN,
dbo_FINDG.FINDG_NO, dbo_FINDG_RSK_LVL.FINDG_RSK_LVL,
First(dbo_FINDG.CMNT) AS FirstOfCMNT, dbo_FINDG.FINDG_RSK_LVL_ID,
dbo_FINDG.FINDG_NME, dbo_FINDG.PLCY1, dbo_FINDG.PLCY2, dbo_FINDG.PLCY3,
dbo_FINDG.PLCY4, dbo_FINDG.PLCY5, dbo_FINDG.PLCY6, dbo_FINDG.PLCY7,
dbo_FINDG.PLCY8, dbo_FINDG.PLCY9, First(dbo_FINDG.NEW_CMNT) AS
FirstOfNEW_CMNT, dbo_FINDG.URL1, dbo_FINDG.URL2, dbo_FINDG.URL3,
dbo_FINDG.URL4, dbo_FINDG.URL5, dbo_FINDG.URL6, dbo_FINDG.URL7,
dbo_FINDG.URL8, dbo_FINDG.URL9, dbo_SYS_INFO.SYS_ID_CODE
FROM ((dbo_SYS_INFO INNER JOIN dbo_FINDG ON dbo_SYS_INFO.SYS_ID_CODE =
dbo_FINDG.SYS_ID_CODE) LEFT JOIN dbo_FINDG_STAT ON
dbo_FINDG.FINDG_STAT_ID = dbo_FINDG_STAT.FINDG_STAT_ID) LEFT JOIN
dbo_FINDG_RSK_LVL ON dbo_FINDG.FINDG_RSK_LVL_ID =
dbo_FINDG_RSK_LVL.FINDG_RSK_LVL_ID
WHERE (((dbo_SYS_INFO.SYS_ID_CODE)=[Forms]![frmSystem]![SYS_ID_CODE]))
GROUP BY dbo_SYS_INFO.SYS_NME, dbo_SYS_INFO.SYS_URL,
dbo_SYS_INFO.TEST_BEGIN_DATE, dbo_SYS_INFO.TEST_END_DATE,
dbo_FINDG.FINDG_STAT_DATE, dbo_FINDG_STAT.FINDG_STAT,
dbo_FINDG.FINDG_NO, dbo_FINDG_RSK_LVL.FINDG_RSK_LVL,
dbo_FINDG.FINDG_RSK_LVL_ID, dbo_FINDG.FINDG_NME, dbo_FINDG.PLCY1,
dbo_FINDG.PLCY2, dbo_FINDG.PLCY3, dbo_FINDG.PLCY4, dbo_FINDG.PLCY5,
dbo_FINDG.PLCY6, dbo_FINDG.PLCY7, dbo_FINDG.PLCY8, dbo_FINDG.PLCY9,
dbo_FINDG.URL1, dbo_FINDG.URL2, dbo_FINDG.URL3, dbo_FINDG.URL4,
dbo_FINDG.URL5, dbo_FINDG.URL6, dbo_FINDG.URL7, dbo_FINDG.URL8,
dbo_FINDG.URL9, dbo_SYS_INFO.SYS_ID_CODE
ORDER BY dbo_FINDG.FINDG_NO;

 

[FA]

If i take out the GroupBy and Where clause, it works fine, but i need
to have atleast "Where" clause, its the requirment.

Any help would be greatly appreciated.

Thanks