'create SQL string
    sSQL = "SELECT  RmaHeader.CustRmaNum, RmaRcvDetail.RmaRcvNum, RmaRcvDetail.RcvQuan, RmaRcvDetail.StockCode, RmaRcvDetail.SNRequired, RmaRcvDetail.ItemStatus, " & _
        "RmaRcvDetail.ExcpStatus , RmaRcvDetail.ExcpType, RmaRcvDetail.ExcpQty, RmaRcvDetail.DupliumRmaParent, RmaHeader.Reference, RmaHeader.CustID, RmaRcvHeader.RcvStatus " & _
        "FROM RmaRcvDetail LEFT OUTER JOIN RmaHeader ON RmaRcvDetail.DupliumRmaParent = RmaHeader.DupliumRmaNum " & _
        "LEFT OUTER JOIN RmaRcvHeader ON RmaRcvDetail.RmaRcvNum = RmaRcvHeader.RmaRcvNum " & _
        "WHERE (RmaRcvDetail.StockCode = '" & sCode & "') AND (RmaRcvHeader.RcvStatus = 'N' OR RmaRcvHeader.RcvStatus = 'P')"