Summing on 3 different values

E

efandango

I want to sum a text box on 3 different values on a form. The values are
1,2,3. Each sum will go into one of three seperate text boxes

How can I say to access '=Sum([Progress])', but only on 1s, and only on 2s
and on 3s. instead of all numbers combined, which is what I get at present.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing 2 different totals in a continuous form 1
Summarizing control based on unique values different field 1
suming up text box from other text boxes that have a sum formula 2
Errors with Sub Form Totals 4
Access Sum function in an Access Form 1
text box summing up other text box but going into table field 1
DSum between dates 1
summing up values of a subform on the main form 3

Top