Access:How to calculate cost of good sold

Closed
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
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.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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.
1
Cgs is Cost of Goods Sold - He/She shortened it...
0