I have two tables in Mysql, one with sales data and the other with salesmen:
Sales Table is Fin_data: deposit_date, closer_id, inv_amount
Salesmen Table users: ID, full_name.
The closer_id links to the ID in the users table.
The user can select a date range e.g. 2009-01-01 to 2009-04-30. All this is working correctly.
The result I want is total sales by salesman for each of the months in the date range and total for the month and grand total for all the months in the range selected.
I would think that this could be done via sql. Hope I am right!