Calculated field

[nashr1928]

I am trying to add or sum all rows in one column to a field on my form. Gosh this is simple but i cant remember. Could someone give me an example that i could put in the field properties?

[Datagopherdan]

You could create a calculated field in a query e.g. MySubTotal:Nz([Field1]) + nz([Field2]). Then in your form use that query as your record source and create an unbound text box and in it's control source. you could do something like nz([MySubTotal]) + nz([MyFormField])

[nashr1928]

I fiqured out what i did wrong. This is what i used that did not work. Sum(name)

This is what im using now that works perfect. =Sum([name])

[Datagopherdan]

Glad you got it figured out.