text TO lcSQLStr TEXTMERGE noshow SELECT cCode_Description as cStatus, ; CAST(SUM(NVL(IIF(BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ; AS iOriginal, ; CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk) ,0,1),0)) AS I) as iCurrent ; FROM MMVisCollect!Trans ; INNER JOIN MMVisCollect!VisCodes ON Trans.cResolution_Codes_fk = VisCodes.cVisCodes_pk ; WHERE iBatch_Number = <<m.tiBatch_Number>> ; group BY 1 ; UNION ALL ; SELECT PADR('Total Closed:',100) as cStatus, ; CAST(SUM(NVL(IIF(BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ; AS iOriginal, ; CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk) ,0,1),0)) AS I) as iCurrent ; FROM MMVisCollect!Trans ; WHERE iBatch_Number = <<m.tiBatch_Number>> and cResolution_Codes_Fk IS NOT NULL ; UNION ALL ; SELECT PADR(cQueue_Name,100) as cStatus, ; CAST(SUM(NVL(IIF(not BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ; as iOriginal, ; CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk),1,0),0)) AS I) as iCurrent ; FROM MMVisCollect!Trans ; INNER JOIN MMVisCollect!Trans_Employees_Queues ON Trans.cTrans_pk = Trans_Employees_Queues.cTrans_fk ; INNER JOIN MMVisCollect!Queue_Names ON Trans_Employees_Queues.cQueue_Names_fk = Queue_Names.cQueue_Names_pk ; WHERE Trans.iBatch_Number = <<m.tiBatch_Number>> ; AND Trans.cResolution_Codes_fk is NULL ; group BY 1 ; UNION ALL ; SELECT PADR('Total Opened:',100) as cStatus, ; CAST(SUM(NVL(IIF(not BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ; as iOriginal, ; CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk),1,0),0)) AS I) as iCurrent ; FROM MMVisCollect!Trans ; WHERE Trans.iBatch_Number = <<m.tiBatch_Number>> ; AND Trans.cResolution_Codes_fk is NULL ; UNION ALL ; SELECT PADR('Batch Total:',100) as cStatus, ; CAST(COUNT(*) AS I) as iOriginal, ; CAST(COUNT(*) AS I) as iCurrent ; FROM Trans ; WHERE iBatch_Number = <<m.tiBatch_Number>> ENDTEXTAs you see, I create three lines with totals. I'd like to present them in different font (bold, bigger size).