Sum

[Guest]

I have some fields that I enter amounts into. I also designated a total box.
How do I sum the total in the fields into my total box. I would like this
to appear in my table so I can use this on another form.
Thanks
Chey

 

[Chelsey Webb]

I have some fields that I enter amounts into. I also designated a total box.
How do I sum the total in the fields into my total box. I would like this
to appear in my table so I can use this on another form.
Thanks
Chey

 

[Guest]

In your query, create a field called Total: sum(field1...fieldn)

 

[Guest]

Stupid question but, what do I put as a separator and do I put the field
names in []?

 

[Guest]

Chey,

It sounds like you are using this sum feature on more than one form. If you
are, then you do not need to store the result in a table; possibly only the
data that you are adding together. You can put the same formula in any form.
You really want to avoid storing calculated data in a table.

In the control source property of a text box on your form, enter:
=[item1]+[item2]+[item3], etc., where [item] is the name of your control(s).