I need to check the income for a particular department for a certain period of time.
My inputs are the two dates between which the income has to be calculated,and the department name,the department name is the primary key for my table
I need to show the transactions for the department for that period of time and also calculate the total income for the department in that time.
I have datetimepicker1 and datetimepicker2 giving the date inputs and combobox1 giving the department name.
Please help me with the sql query.
Thank You :)