Access:How to calculate cost of good sold

yogesh01 Posts 4 Registration date Saturday July 3, 2010 Status Member Last seen December 3, 2010 - Jul 24, 2010 at 03:47 AM
 Shaina - Oct 31, 2010 at 08:32 PM

I need some basic help .I have a table with three field , Sales Cgs and Average profit. I want to create a form based on that table .the problem is I dont know how to calculate the cost of good sold using access form .I need to calculate cgs and store it in cgs field.

I have to enter cost per item from purchase once a week and enter total sale every day.How do i multipy the quantity of sale with cost per item ?
Thank you.


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 26, 2010 at 08:07 AM
I am not sure what is "Cgs". How ever you can have the text box based on a formula on the form.
Cgs is Cost of Goods Sold - He/She shortened it...