creating a report that preforms a calcualation

[scott6480]

I am very new to access and i am trying to create a report that shows expenses for each deal transactions.

I have a table freight and a table storage.

I need to run the report that will thake the total $ storage and total $ warehousing fee (if there is any) and add them by deal number which both tables have.

can someone give me a hint at what i need to do?

 

[jbpez]

Base your report on a query like this

SELECT (SUM([Storage$])+SUM([WarehousingFee$])) AS Total
FROM TableStorage INNER JOIN TableFreight ON TableStorage.DealNumber = TableFreight.DealNumber
GROUP BY TableStorage.DealNumber

John Borges