Do you store your costs in the product details? Can't you just add another field with your costs and total them below?

If your costs are somewhere else for some reason you can just join them in a query or dlookup them.

If you're trying to combine costs of different materials used to create one product. (This part takes 1 screw and 2 pieces of wood for instance) and then getting the cost from that. I THINK Rick covers it in the https://599cd.com/blog/display-article.asp?ID=1628 Access Work Order Seminar

<a href="https://599cd.com/blog/display-article.asp?ID=1628">Access Work order Seminar </a>

Just testing if I can use html on forum now

Also from Developer 20 on thru developer 27 I think Richard shows how to develop an Order Invoice.  Concept is similar as you add items and Qty. it sums up the value.  Replace the products with your items and added bonus LOL it makes an invoice. :)
V/r
Juan  

hello Adam

I will have a look at that thank you I'll put a new column in cold my costs and put in the costs and see what happens

Hi guys. Yes, if your unit-to-product ratio is one to one (in other words, you pay one price for each product you sell), then I cover tracking unit cost over the next couple of lessons including Expert 11 where I show you how to determine the lowest cost from multiple vendors. And yes, the Work Order Seminar. However, it's really nothing more than Adam says - just put an extra field in your product table to store YOUR cost, then copy that over to your order detail table, then sum it all up.

However, if you want to BUILD a product from components you buy separately, then that involves some coding. I'll be covering it with Recordsets in an upcoming Developer class. Much more complicated. For example, if you sell computers, you purchase the individual components from your vendor, want to add labor and markup, and then sell that as ONE unit, then that's a whole different story. That's coming.