Totals on a report

[NoviceIan]

Is it possible to total fields in an existing report? I basically got a
report of our organisations current service profile and was wondering wether
it would be possible to total the hours and WTE of each team.

If so please let me know thanks alot
Ian

 

[Marshall Barton]

Is it possible to total fields in an existing report? I basically got a
report of our organisations current service profile and was wondering wether
it would be possible to total the hours and WTE of each team.

That's a pretty vague problem description so about I can say
is that you can use the Sum function in a group and or
Report header/footer section text box. E.g. a text box in
the team group footer section could use:

=Sum(Hours)
or
=Sum(WTE)

Note that Hours and WTE must be the names of **fields** in
the report's record source table/query. They can not be the
names of controls on the report.