>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
This might be really dumb, but is the field Numeric (they default to Character)?
Failing that, do you have any report variables set up?
Does the detail band print properly?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up