strReportSQL = "SELECT " & strReportType & " as GroupName, count(*) as Qty2, fldDiscount, ord2.SubTotal " & _
                    "From tblOrders ord1 Left Join ( " & _
                        "SELECT " & strReportType & "  as GroupName, count(*)  as QTY, Sum(fldQuantity *  fldProdPrice) as SubTotal " & _
                        "From tblOrderItems as item, tblProducts as prod, tblOrders as ord " & _
                        "Where item.fldProductID = prod.fldID " & _
                        "and item.fldOrderId = ord.fldID " & _
                        "and fldPartyDate >= #" & strDateStart & "# And fldPartyDate <= #" & strDateEnd & "# " & _
                        "Group by " & strReportType & " " & _
                    ") as ord2 ON ord1." & strReportType & "     = ord2.GroupName " & _
                    "Where fldPartyDate >= #" & strDateStart & "# And fldPartyDate <= #" & strDateEnd & "# " & _
                    "group by " & strReportType & ", SubTotal "