strReportSQL = "SELECT " & strReportType & " as GroupName, count(*) as Qty2, 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 "

şöyle bir kod wwar.. bunu listelerken tblOrders tablosundaki fldDiscount alanını da alarak listeye eklemek istiyorum.. bir türlü işin içinden çıkamadım.. işin üstadı olan bakınca tık diye halledecektir..