F
FA
I have the following query;
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 AS
SMRY, dbo_FINDG.RSK_DESC AS RSK_DESC, dbo_FINDG.RCMN AS RCMN,
dbo_FINDG.FINDG_NO, dbo_FINDG_RSK_LVL.FINDG_RSK_LVL, dbo_FINDG.CMNT AS
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 AS 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,
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))
ORDER BY dbo_FINDG.FINDG_RSK_LVL_ID DESC , dbo_FINDG.FINDG_NO;
// I am having a problem with the SYS_NME and SYS_URL,TEST_BEGIN_DATE,
TEST_END_DATE i want these field to apear once in the query. The above
query gives me each record and in each record i see the repeated
SYS_NME and SYS_URL,TEST_BEGIN_DATE, TEST_END_DATE. I do not want to
see these field with each record, instead i want to see it with only
first record. The reason why i want it this way because i am mail
merging this query's results into MS word and when i mail merge it,
these fields apear with every record but in the word document i only
want to see it once.
Is there any function in ms access query that can do such thing?
your help would be greatly appreciated
thanks
Moe
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 AS
SMRY, dbo_FINDG.RSK_DESC AS RSK_DESC, dbo_FINDG.RCMN AS RCMN,
dbo_FINDG.FINDG_NO, dbo_FINDG_RSK_LVL.FINDG_RSK_LVL, dbo_FINDG.CMNT AS
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 AS 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,
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))
ORDER BY dbo_FINDG.FINDG_RSK_LVL_ID DESC , dbo_FINDG.FINDG_NO;
// I am having a problem with the SYS_NME and SYS_URL,TEST_BEGIN_DATE,
TEST_END_DATE i want these field to apear once in the query. The above
query gives me each record and in each record i see the repeated
SYS_NME and SYS_URL,TEST_BEGIN_DATE, TEST_END_DATE. I do not want to
see these field with each record, instead i want to see it with only
first record. The reason why i want it this way because i am mail
merging this query's results into MS word and when i mail merge it,
these fields apear with every record but in the word document i only
want to see it once.
Is there any function in ms access query that can do such thing?
your help would be greatly appreciated
thanks
Moe