>>>>>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?
>>>>>
>>>>>Thanks,
>>>>>
>>>>>Michelle
>>>>
>>>>Hi Michelle,
>>>>
>>>>How many decimal places it gives you?
>>>>Did you try to change the report field width?
>>>
>>>4. The size doesn't matter. No matter how big I make it, if I have a mask, it doesn't print anything.
>>>
>>>Thanks,
>>>
>>>Michelle
>>
>>So is the field physically large enough on the report form? Maybe all you're seeing is the leading spaces? Try making the field on the report larger, using Shift-RightArrow after you've selected it.
>
>Didn't matter how big I made it. I even had on the Stretch With Overflow. Turns out I needed the mask to have more characters even though the number never got that big. It's working, now.
>
>Thanks,
>
>Michelle

Hmm, on mine if the mask is not big enough, I get asterisks.