Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query criteria negates Replace Function??

Status
Not open for further replies.

gwoman

Programmer
Nov 16, 2004
199
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top