Averaging Percentages in a form

[DICKBUTTONS]

Being a Novice at Access I'm not even sure this is possible......here is my question;

I have a form that stores sub-tasks % complete (10 of them) that are part of one major task % complete.

The major task % is calculated from the 10 sub-task percentages....what I would like Access to do is ignore the sub-tasks that are not used.

Not all major tasks will have 10 sub-tasks....but my calculation will only work if all ten spots have a percentage listed even if I enter 0% it throws off the average.

Is it possible to ignore the unused fields?? Here is my calculation field

=([Text100]+[Text102]+[Text104]+[Text106]+[Text108]+[Text110]+[Text112]+[Text114]+[Text116]+[Text118])/10

http://i170.photobucket.com/albums/u...S/screen-2.jpg

[RuralGuy]

If you judicously name your controls ...1 to ...10 then this function will do it.
Warning >>> AIR CODE <<<

Private Function MyAverage() As Double
   Dim Accumulation As Double
   Dim Counter As Integer
   Dim Available As Integer
   For Counter = 1 To 10
      If Len(Me.Controls("YourName" & Counter) & "") > 0 Then
         ' This control has a value
         Accumulation = Accumulation + Me.Controls("YourName" & Counter)
         Available = Available + 1
      End If
   Loop
   If Available > 0 Then
      MyAverage = Accumulation / Available
   Else
      MyAverage = 0
   End If
End Function