Memo Field Data being truncated with agregate function

F

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;

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
 
G

Guest

Hi FA,
I came across this issue yesterday too. And I just found a workaround,
thought you might give it a try too.

1. Take out all grouping and where condition from the existing query.
2. Create another query based on the existing one.
3. In the new query, add additional column(s) used in groupby, specify
groupby. Add column(s) used in where clause, specify where clause. make
sure these newly added columns are not in the select statement, i.e. in
design view, don't check those checkboxes.

Run the query, step 1 should pull out Memo field text without truncation.
Step 2 and 3 allow you to group and filter records based on step 1.

Hope this helps.

-adam


FA said:
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;

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo Field data is being truncated in mail merge 1
MS Access Query Issue 17

Top