Calculating the average of 10 fields

[joce]

Hi,

I am trying to calculate the average of 10 fields together but my expression doesnt seem to be working. I am enjw to this so any help would be really appreciated.

The expression looks like folows at the minute,

CowBCSAverage: (Nz([Cow1BCS])+Nz([Cow2BCS])+Nz([Cow3BCS])+Nz([Cow4BCS])+Nz([Cow5BCS])+Nz([Cow6BCS])+Nz([Cow7BCS])+Nz(Cow8BCS])+Nz([Cow9BCS])+Nz([Cow10BCS]))/10

Joce

 

[Brianwarnock]

You have a syntax error missing[ at cow8bcs

Brian