Hi FishVal,

I really appreciate all your help in this matter. But I am still not able to get this to work. I am trying to do this inside Access 2003 and it may not have the capabilities to process the SQL that you have created.

To compound matters, I can't find the Edit button that would allow me to attach a file. I've searched the help section, searched the forums, but I can't find anything. It's very frustrating....

Please excuse my ignorance, but I don't see how to attach files. The help file says

I don't see this browse button anywhere....

Thanks for the feedback. I've never used the DMax function before. I don't necessarily want the maximum cost of the part at any point in time. What I want is to be able to say on this DateSold, the cost of the StockCode at that time was X amount of dollars. The problem I have is that dates don't match in the two tables. For example, the cost could have changed on Feb. 1st and then again on Feb. 10th, but we sold some on Feb. 3rd and Feb. 12th....

I have two tables in an Access database. Table "StockCodeC ost" stores the StockCode, Cost, and Date (for when the cost of the StockCode changes). This table essentially keeps track of any price change for the StockCode.

Then I have another table "StockCodeSales ". This table stores the StockCode, QTYSold, and DateSold.

I want to create a query that can show me the sum of the costs for each transaction...