Ok, I'll have a look at it tonight at home when I have more free time. I'm not sure what could be causing the problem with the calculation in the table so it may take a bit of time to go through everything. Will it be a problem if I make changes in the hierarchy? The form will look exactly the same,...

Hi Kathleen,I think this form may be corrupted. The sums in the table are giving me problems no matter what I do. Most of the issues you were getting errors on were simple case mismatches (i.e. - goalcount instead of goalCount) but something definitely appears wrong with the table. Has this form bee...

Sure, I'll take a look and see what I can do. If I have questions I'll shoot you an email.

Hi Kat,I've made a change to the form I sent you yesterday and emailed it to you, the error is taken care of.

That's not one of the scripts I added so I'm not sure where it is on your form, but I see that it's calling out a division by zero so there must be something wrong with your TOTALESSENTIALduties field or variable. Whatever TOTALESSENTIALduties is, it should have a 2 in it right from the start becaus...

It's not a problem, I added the fields that were missing and sent the form back to you. The totals and averages now work and I put a couple of examples of checking to see whether or not previous fields had been filled in. Hope it helps.djaknow

Please send me the form atallendavid@co.kane.il.us. I'll get it fixed up for you and send it back and then you'll have the code as a sample for future reference.

Again, you'd be doing a check for null, i.e.:var dutyCount = 0;if (Duty1.rawValue != null){     dutyCount = dutyCount + 1;}if (Duty2.rawValue... etc.this.rawValue = dutyCount;This script would go on the calculate event of the "Enter Total Number of Essential Duties and Responsibilites". It'll displa...

You could do a simple check for null and increase a counting variable if there's a value in the field. Here's a sample:var goalCount = 0;if (field1.rawValue != null){     goalCount = goalCount + 1;}if (field2.rawValue != null){     goalCount = goalCount + 1;}if (field3.rawValue... etc.this.rawValue ...

I sent the form back Joe along with an explanation and a screenshot of what I changed.