I want to help my little project about

I want to help my little project about:
First: I want  report a select, as well as the report of the total.

Second: In the reports I want to see the total (sum total mb +total ms).

Third: when I sell a piece in the sales department to change the color in the Purchases field to the green color.