Calculating the sum of a field for all records with a unique ID

[bkupper23]

Hello everyone,

I am trying to add up all my labor costs on my subform.

The subform saves all the operations and associated labor costs under the same quote number.

I am trying to calculate in the subforms footer the total labor costs for all the records.

This is a dynamic situation because I may have 1 operation or 10 operations.

Any help or just general guidance would be appreciated.

This is my first go in a long time with Access.



Thanks in advance!

Brandon

[ranman256]

In the sub form, add a footer, in it put a text box,
this is the sum of the field.....
=sum(field)

[bkupper23]

So that's what I had done. The problem is it only pulls the data from the field of the record I'm on. I want it to pull all the records created on that particular subform.

[aytee111]

What you are saying can't be right! Show us the control source for that field.

[bkupper23]

I attempted to try what you suggested again and I am getting #error as you can see in the picture.

Another thought was to just create another subform on the main form to calculate the total from a query.

This works, however I am having a hard time updating the results when new input is made on subform 1. The data only refreshed upon opening back up the form.

I think your suggestion would be much cleaner so I am trying to get that to work.

[bkupper23]

My god.

I feel like an idiot. I was tallying the text box and not the control itself.

Thanks for your help in this!

[aytee111]

Don't sweat it, we need people to bounce things off sometimes!