Trying to get TOTAL SALES...

[hopkinsc]

Hi, i have a Stock Movement app which i am having trouble displaying TOTAL SALES on.

In the app the user selects the 'Stock Movement' that they wish to view..

i.e.

Wastage

Reductions

Goods Received

etc

I am loading in a product sales table and movement table.

After the user selects a Movement Reason (lets say Wastage for this example), only the sales for the day of the wastage is displayed.

I want the app to display the TOTAL SALES for the product regardless of any other movement or not.

See example below of the WRONG result..

And the result i want to see is 1 line (as its only the top line that has waste against it) but with the total sales of 44, not 7.

Does anyone know how i can achieve this?

[#2]

Good show.  are you able to flag this as answered?

Cheers