>Hi there,
>
>I am trying to figure out how to create a report var calculation an average value but avoiding records where the value of the field is o. How can I do this?
>
>Thanks in advance
>
>Thomas
SUM(FIeld) / SUM(IIF(Field = 0, 0, 1))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.