I have a query where I perform the replace function on 2 columns called Defect_qry:
Defect_qry
SELECT TEMP_FACILITIES_TEMP_DB_BUG.BG_BUG_ID AS FORMID, IIf(IsNull([BG_DESCRIPTION]),'',Replace([BG_DESCRIPTION],'<*>','')) AS DETAIL, TEMP_FACILITIES_TEMP_DB_BUG.BG_PRIORITY AS PRIORITY, TEMP_FACILITIES_TEMP_DB_BUG.BG_USER_08 AS [MODULE], TEMP_FACILITIES_TEMP_DB_BUG.BG_STATUS AS STATUS, IIf(IsNull([BG_USER_25]),'',Replace([BG_USER_25],'<*>','')) AS COMMENTS,
FROM TEMP_FACILITIES_TEMP_DB_BUG;
Defect_qry is a subquery for Active_ Defects_qry:
Active_Defect_qry:
SELECT Defect.DEFECTID, Defect.DETAIL, Defect.PRODUCT, Defect.MODULE, Defect.STATUS, Defect.COMMENTS
FROM Defect
WHERE (((Defect.PRODUCT)="Lego") AND ((Defect.MODULE)="Facility Monitoring") AND ((Defect.STATUS)<>"Closed" And (Defect.STATUS)<>"Declined" And (Defect.STATUS)<>"Deferred"));
When I run the Defect_qry on it's own all the html tags are removed from the Detail & Comments Columns. When I run the Active_Defect_qry (where Defect_qry is a subqry) then the html tags are still there. I narrowed it down to the criteria on the STATUS column. If I remove the STATUS column criteria the query works fine.
Any suggestions?
Many thanks in advance!
gwoman
Defect_qry
SELECT TEMP_FACILITIES_TEMP_DB_BUG.BG_BUG_ID AS FORMID, IIf(IsNull([BG_DESCRIPTION]),'',Replace([BG_DESCRIPTION],'<*>','')) AS DETAIL, TEMP_FACILITIES_TEMP_DB_BUG.BG_PRIORITY AS PRIORITY, TEMP_FACILITIES_TEMP_DB_BUG.BG_USER_08 AS [MODULE], TEMP_FACILITIES_TEMP_DB_BUG.BG_STATUS AS STATUS, IIf(IsNull([BG_USER_25]),'',Replace([BG_USER_25],'<*>','')) AS COMMENTS,
FROM TEMP_FACILITIES_TEMP_DB_BUG;
Defect_qry is a subquery for Active_ Defects_qry:
Active_Defect_qry:
SELECT Defect.DEFECTID, Defect.DETAIL, Defect.PRODUCT, Defect.MODULE, Defect.STATUS, Defect.COMMENTS
FROM Defect
WHERE (((Defect.PRODUCT)="Lego") AND ((Defect.MODULE)="Facility Monitoring") AND ((Defect.STATUS)<>"Closed" And (Defect.STATUS)<>"Declined" And (Defect.STATUS)<>"Deferred"));
When I run the Defect_qry on it's own all the html tags are removed from the Detail & Comments Columns. When I run the Active_Defect_qry (where Defect_qry is a subqry) then the html tags are still there. I narrowed it down to the criteria on the STATUS column. If I remove the STATUS column criteria the query works fine.
Any suggestions?
Many thanks in advance!
gwoman