Access:How to calculate cost of good sold

Closed
yogesh01 Posts 4 Registration date Saturday 3 July 2010 Status Member Last seen 3 December 2010 - 24 Jul 2010 à 03:47
 Shaina - 31 Oct 2010 à 20:32
Hello,

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.

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
26 Jul 2010 à 08:07
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...