Totals on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
NoviceIan said:
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.
Click to expand...


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.
 
Back
Top