Data being truncated

[FA]

Hi Friends,
I have a query called qryFindingReport, i am dumping the results of
this query in a table called tblTemp. Then i am mail merging the data
in tblTemp to MS Word. The problem i am having is the data in the
fields are being truncated, meaning sometimes its only showing half the
data of the field sometimes it just show one line. I checked the data
results in the query and its also the same problem. I dont know what to
do. But suprisingly i have the same query with MS Access Report and the
all the field data is showing in that report. Its just confusing ...

Any help would be greatly appreciated.

Thanks
Moe

 

[Rick B]

Why are you dumping it to a table, then mail merging? You can use a query
as a mail merge source.

 

[Guest]

Is the missing data from a Memo field perchance?

 

[FA]

Because the query statement is not working in my VBA Codes. Its saying
No data was created for this merge, make sure the sql statement is
correct. The following i tried but its giving me error that the sql
statement is not correct.
MergeNoPrompts "FindingReport", "C:\Word", True, "FindingReport", _
"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," & _
"dbo_FINDG.SMRY, dbo_FINDG.RSK_DESC, dbo_FINDG.RCMN,
dbo_FINDG.FINDG_NO, dbo_FINDG_RSK_LVL.FINDG_RSK_LVL," & _
"dbo_FINDG.CMNT, 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.NEW_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 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.SMRY, dbo_FINDG.RSK_DESC,
dbo_FINDG.RCMN, dbo_FINDG.FINDG_NO, dbo_FINDG_RSK_LVL.FINDG_RSK_LVL,
dbo_FINDG.CMNT, 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.NEW_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 ORDER BY
dbo_FINDG.FINDG_NO"

It did not work.

Please help me out. Thanks

 

[FA]

Yes defenitely,

What could be the possible solution.

Thanks bunch

Moe