>Does anyone have a way to compute a average of data in footer bands. Data with value of 0 should not be counted in average.
>
>In other words if data in shown in detail band is 16, 0, 0, 0 the average should be 16 not 4.
>
>Ken
I dunno if it'll work but you can try to convert zeros to NULLs
IIF(myfield=0, CAST(NULL AS I), myfield)
--sb--