G
Guest
I have a invoicing data base I created.I have been able to create a report
that gives me the total sales broken down down by the month.
I would like to to create a report that will display all the products and
give the total number of units sold per item also broken down by the month. A
sample of how I want to look like is below.
Item Product January February March
April etc Total
Number Name # sold # sold # sold #
sold sold
101 Light Bulb 40Watt 6 14 5
4 >>>>> 90
my invoice form has 5 lines per invoice for 5 different products, and each
field has its own name (ie, ItemNumber1, ItemNumber2, ProductName1,
ProductName2, etc.)
can anyone help me with this?
that gives me the total sales broken down down by the month.
I would like to to create a report that will display all the products and
give the total number of units sold per item also broken down by the month. A
sample of how I want to look like is below.
Item Product January February March
April etc Total
Number Name # sold # sold # sold #
sold sold
101 Light Bulb 40Watt 6 14 5
4 >>>>> 90
my invoice form has 5 lines per invoice for 5 different products, and each
field has its own name (ie, ItemNumber1, ItemNumber2, ProductName1,
ProductName2, etc.)
can anyone help me with this?