[newbe]

Hi All, New to Access looking for a little help with building an expression I'm looking to provide a total for a number of records here is what I'm looking to achive, I'm looking to Calculate the sum of all of the costs from the cost feild...

Hi All, New to Access looking for a little help with building an expression

I'm looking to provide a total for a number of records here is what I'm looking to achive,

I'm looking to Calculate the sum of all of the costs from the cost feild in the query called [product costs] that have the same detail in the OrderID feild on the query called [Product costs] but don't know how to build the expression.

I then need to show this total on a form when the data in the feild OrderID from the table [Orders] will show the results of the query for data matching the orderID feild.

(The query [product costs] does the calculation of product cost*Quanity ordered.)

So that I if I open a form with orderID 20 it will add together all of the costs from the products linked to that OrderID

Hope this makes sence and hope you can help