column total not showing up in form view

[Lori2836 via AccessMonster.com]

Can someone help? I have a column total that doesn't show up on my form. I
have a calculation in my control source, to give me the total. Here is the
calculation I am using: Am I doing something wrong? I don't get an error
message, just a blank cell.

=Sum(([Hrs/M1]*94.45+[Hrs/M3]*94.45+[Hrs/M5]*94.45+[Hrs/M7]*94.45+[Hrs/M9]*94.
45+[Unit Cost2]+[Unit Cost4]+[Unit Cost6]+[Unit Cost8]+[Unit Cost10]))


Thanks for any help I can get on this.

 

[Allen Browne]

If any one of those fields is Null, the total of the calcuation will be
Null.

For more info, see Error #2 in this article:
Common Errors with Null
at:
http://allenbrowne.com/casu-12.html

You also need to consider the possibility that any of the divisors (such as
M1) could be zero, which would lead to a division by zero error.

But the core issue here is that you have many repeating columns. That's
common in a spreadsheet, but it is not how you design a database. You need a
related table with many records instead of the repeating fields. For more
info, read up on normalization. Here's a starting point:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101