I have a relational database containing reseller details, sales records, stock levels etc.
I'm quite happy with the way it's working, however, I have run into some problems as I try to create some meaningful reports to run.
I have a 'sales details' database containing all of my sales information. I want a sales report that can show me the total sales for all my products, by month or year or region or whatever.
The issue I have is as follows. When I find all of my sales, say for a particular month, I get something that looks like this as I have different resellers making sales of the same product in the same month.
Item ----- Quantity
ProductA ----- 1
ProductA ----- 1
ProductA ----- 3
ProductB ----- 1
ProductB ----- 7
PrdocutC ----- 1
ProductE ----- 1
ProductE ----- 4
Can anybody suggest a useful way to generate a report which would total these for me? I do have a separate file for stock items I could run some script against but I haven't been able to think of a way to make it work.
Any help would be appreciated.