Access:How to calculate cost of good sold

[Closed]
Report
Posts
4
Registration date
Saturday July 3, 2010
Status
Member
Last seen
December 3, 2010
-
 Shaina -
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am not sure what is "Cgs". How ever you can have the text box based on a formula on the form.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Cgs is Cost of Goods Sold - He/She shortened it...