I have the the following database structure:
Product_ID - Product_name - Product_issue_date
Product_ID - amount - date
Now i want to report the total of each product.
The result should look like this:
Product 1 - 5,000
Product 2 - 3,500
Product 3 - 4,430
How can i do that?
I tried it with a running total field, like
[product_name] - [#total]
But then the result looked like
Pruduct 1 - 500
Product 1 - 4500
Product 2 - 3000
Product 2 - 500
Product 3 - 4000
Product 3 - 430
So basically it should read out all Product names and then
calculate the totals for each product.
Thanx for the help.