Sum Multiple Form Fields

[cityanangelstx2004]

I have been unsuccessful using sum and dsum in access. I have twelve fields in my form, january through december. I want to create a running total of the entered amounts. I think the problem is due to the fact only a few months contain data, such as january through march. The other fields are blank. I also attempted to do this in a query and no luck. Does anyone have a simple and quick solution. Any help is greatly appreciated.

 

[Norie]

Why do you have seperate fields for the months?

You should really only have one field for the data you currently hold in these fields and another field indicating the month the data refers to.

This would probably help with your summing problem.