>>I have a field in the detail band that I want the average of in the group footer and summary. I copied the field to the two places and clicked "average" under calculations.
>>
>>The problem is that I don't want to see the decimal places. So I put a format of 999. It doesn't print anything. Not astrisks, not anything. If I don't put a format, it prints the number with all the decimal places. I tried ROUND(gpmper,0) and that doesn't work, either.
>>
>>Any ideas?
>>
>
>Rather than carrying the average per se, perhaps carrying the sum of the values being averaged and the count of items as two discrete values; your average would then be SumOfItems/MAX(CoutOfItems,1); you could then ROUND(), FLOOR() OR CEIL() that to get the integer representation you wanted.

Thanks, but it was much easier just to make the mask bigger. :)

Thanks,

Michelle