[macropod]

Hi John,

Here's a simpler field construct to work with:
{=SUM({=Field1},{=Field2},{=Field3},{=Field4},{=Fi eld5},{=Field6},{=Field7},{=Field8},{=Field9},{=Fi eld10})/
SUM({=Field10},{=Field20},{=Field30},{=Field40 },{=Field50},{=Field60},{=Field70},{=Field80}, {=Field90},{=Field100})}

Cheers

--
macropod
[MVP - Microsoft Word]


"JohnS" wrote in message ...
| I've got 10 Text Form Fields that are all named. I want to average the
| numbers that are entered into those fields. The only problem is that not all
| fields are used every time. I've tried this two ways and neither seems to
| work.
|
| The first is "=average(field1, field2, etc.)". This only works if all
| fields are used.
|
| The second way is to sum the results of the fields, then divide that by a
| count of the fields in use. To get the count of the fields in use I used a
| separate field for each that calculates "=(if, field11,1,0)", then I sum all
| those up to get the number. I can get the sum and the count to work, but
| when I divide the sum by the count it doesn't work.
|
| Any ideas?