Add up values based on two SEPARATE text fields (1 Viewer)

I am creating a database that tracks produce thrown away in my department and produces reports based on this information. We stock over 500 items (each with its own unique name), and when thrown away they are tracked by one of eight codes.
The resulting report shows that on any given day we throw away $15 of Apple A because of reason Q5, then later the same day we again throw out ANOTHER $2 worth of Apple A for reason Q5.
What I am attempting to achieve is that when the system sees that Apple A was thrown out more than once, it will add these and display the total sum of Apple A being thrown out for Q5, rather than listing every instance that this happens.

Any help will be greatly appreciated!

Tim

Play with this query:

SELECT [SAL2: SALVAGE LOG].[ITEM DESCRIPTION], [SAL2: SALVAGE LOG].[REASON FOR LOSS], Sum([SAL2: SALVAGE LOG].[AMOUNT OF LOSS]) AS [SumOfAMOUNT OF LOSS]
FROM [SAL2: SALVAGE LOG]
GROUP BY [SAL2: SALVAGE LOG].[ITEM DESCRIPTION], [SAL2: SALVAGE LOG].[REASON FOR LOSS];

Hi. Not in front of a computer now but have you tried using a Totals query?

Edit: Oops, too slow...

Agree with the suggestions already made.
In addition the two calculated fields in the Salvage Log table are unnecessary.
You should use a query to do those calculations when needed.