VBA code to get sum from multiple entries

[budchevy]

I have a form setup that will allow multiple users to enter the number of units they counted. I would like to get the total of those entries and have it auto populate to a total field..

I also have a seperate place where they can enter an error quantity & a price. I would like to multiply these together to get a seperate total price.

Not sure how to accomplish this.

[John_G]

Assuming that all the individual users are entering records into the same table in a shared database, then to get the total of the counts you could probably use the DSum(...) function, perhaps with criteria to sum only the records you want.

The second part of your question is not very clear - but if you want the sum of ([quantity] * [Price]), where [Quantity] and [Price] are fields in a table, then DSum can do that as well.

If this does not answer your question, please give some better detail obout what you are trying to do.

HTH

John

[budchevy]

John,
I have attached 2 of the forms i'm using and here's a list of things I'm trying to accomplish..
-Need to have FrmULPD fill in the Units Counted field by adding up anything put into the units counted field for each of the auditors, compute the percent complete based on units allocated divided by units counted and then have the total ROI filled in based on all the total ROI fields from the subform
-In the subform, need to have ROI filled in based on quantity * cost