Sum fields in a form

[AKQTS]

I am building a form where a user can enter an order # and multiple parts will populate on that order. Within that form there are user entry fields where they can enter the amount of components rejected for 6-7 reasons (columns) for each part number, i.e. damaged, dosen't match print, etc. This is all done in the details section where depending on the order 5 -50 parts may populate.

I want to total the amount rejected for each part (total the 6 or 7 reject reason fields).

Setting up an unbound text box and programming a basic sum expression, it works, but in the rejects total column it lists the total rejected for the entire order in the row for each part and not the total for that specific part. How do I get it to only sum the total rejects for each part? thanks

[cowboy]

You are going to have to explain a little more, like how does your form get its information. Is it a continuous form? Post a jpeg if you can.

[AKQTS]

What I am trying to do is sum the central fields with the light borders (i.e. "Sealer set-up" to "Others") into the "Total Rejected" field for each row.

If correct, the second row would say 3 in the Total Rejects box and the third row would say 1 in the Total Rejects box...

When I create an unbound text box for total rejects it sums all the part numbers in the list. In this case it would say 23 in all the rows in the Total Rejected column.

All you see above is done in the details section and all the information is queried from the same table into the form.

Any help would be great or if anymore info is needed, let me know. Thanks again.

[cowboy]

=Nz([txt1])+Nz([txt2])+Nz([txt3]).... use the name of the textboxes instead of txt1 ...
I am guessing this is a continuous form but this should work.

[AKQTS]

Awesome, worked great, Thanks cowboy

[cowboy]

no problem, mark the thread as solved plz