Respected sir/s,
i m using ms-access as backend and vb.net as front end for developing windows application...
In which i m using query for generate monthly report..
like bellow
Item_Name TotQntyPurchsed TotQntySale TotQntyInStock
-------------------------------------------------------------
abc 15 10 5
xyz 20 18 2
--------------------------------------------------------------
here all the columns are grouped by for getting respective item total...
but i want this for every month..
then how can i do this with group by clause because sale and perchase will be on daily basis
or
any other idea to achieve this...?
plz help me..
thank you