>Is there a way I can get rid of the long decimal places for average in the report?
You could format the output (double click on the field in report designer) -- 999,999,999.99 will limit your average to 2 decimal places. For your country, do you use a period for a decimal and commas to separate hundreds, thousands, etc.?
Mark McCasland
Midlothian, TX USA