Text Box to Display Total

[maabbas]

Guys banging my head to wall :banghead: is not solving my issue.

There are 2 images I am inserting, I want on the Access form to display the total of row (each row is batch number) in the box after pressing the button in the form. based on Product code, date and table numbers.

 

[maabbas]

Forget to insert images

 

[pr2-eugin]

Have you considered using DSum method?

 

[maabbas]

Have you considered using DSum method?

Not yet will you please explain me little more.

 

[pr2-eugin]

I have given a hyperlink. Check it out - http://www.techonthenet.com/access/functions/domain/dsum.php

Also your description says something and your Screen shots is totally different from that (or) does not reflect what needs to be done !

 

[maabbas]

I have given a hyperlink. Check it out - http://www.techonthenet.com/access/functions/domain/dsum.php

Also your description says something and your Screen shots is totally different from that (or) does not reflect what needs to be done !

The hand written sheet is the data we collect on the production floor, one sheet represent the table number, and each table has 12 employees. we weigh manually each container and write down the total lbs. there are different product produce during the day.

Due to the error in data enter in Access I want something a textbox which display the total so data entry person in Access verify that he/she enter the correct amount.

Write now I am thinking to make 5 text boxes as you see in the image. I use the following code in the command button 166.
Private Sub Command166_Click()
Me.TextTable = Me.Table_Number
Me.TextDate = Me.Production_Date
Me.TextProduct = Me.ProductID
Me.TextBatch = Me.Batch_Number
End Sub
I just need formula to calculate if all above text boxes are true.

 

[maabbas]

The hand written sheet is the data we collect on the production floor, one sheet represent the table number, and each table has 12 employees. we weigh manually each container and write down the total lbs. there are different product produce during the day.

Due to the error in data enter in Access I want something a textbox which display the total so data entry person in Access verify that he/she enter the correct amount.

Write now I am thinking to make 5 text boxes as you see in the image. I use the following code in the command button 166.
Private Sub Command166_Click()
Me.TextTable = Me.Table_Number
Me.TextDate = Me.Production_Date
Me.TextProduct = Me.ProductID
Me.TextBatch = Me.Batch_Number
End Sub
I just need formula to calculate if all above text boxes are true.

any thoughts?

 

[maabbas]

any thoughts?

Guys need help here