how do i format the group totals in report to show thousands etc?

Nyima,
Format : Standard
Decimal Places : 2
OR
Format : +#,###.00;-#,###.00;.00;.00
Decimal Places : 2
This last example will display...
+1,234.56 for positive numbers
-1234.56 for negative numbers
.00 for zero values
.00 for null values

Place your cursor in the format property box, and hit F1.
That will display Help on formatting all types of data values.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Nyima" wrote in message
...

Nyima wrote:
[Nothing]


An example of what you want might get you a useful answer
more quickly than when we have to guess.

Set the Format property of the text box that calculates the
total to use whatever you want. Maybe as simple as #,##0,
but that's just a guess. See VBA Help for
Format Property - Number and Currency Data Types
for a list of the formatting specification codes.

--
Marsh
MVP [MS Access]