>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?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison