'Mechanic Operation Shop' GROUP BY transaction_types.accounting_group, t.transaction_type, year(t.date), quarter(t.date), month(t.date) ORDER BY year(t.date) DESC, quarter(t.date) DESC, month(t.date) DESC, transaction_types.accounting_group, t.transaction_id;"; $Recordset1 = mysql_query($query_Recordset1, $YBDB) or die(mysql_error()); //$row_Recordset1 = mysql_fetch_assoc($Recordset1); //Wait to fetch until do loop $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?>

Monthly Transaction Totals

Year Month Transaction Type Total Count Accounting Group