Summing on a per-day basis

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

Guest

I have a report set up which we use to schedule people's time. It currently
has fields which we type a number into for the "number of hours" allocated to
a job and this will show on the report. Our report is broken up on a daily
breakdown; for example, it would print that there are 5 jobs for today
November 5, and each one has 3 hours allocated. What I want to do is total
the number of hours we have scheduled in a day, on the report, and show this
in the section for that day. So today would show Total hours: 15. Does this
make sense?
Any suggestions on how to do this? I know it can be done, I'm just not sure
how.

Thanks in advance,
Melissa
 
Melissa.
You could use a copy of your current report and create a grouping by date,
and create a footer for this group.
Now, in the date footer band insert an unbound textbox and insert:
=Sum([NumberOfHours])
Substitute the name of your hour field.
Hope this helps.
Fons
 
Melissa.
You could use a copy of your current report and create a grouping by date,
and create a footer for this group.
Now, in the date footer band insert an unbound textbox and insert:
=Sum([NumberOfHours])
Substitute the name of your hour field.
Hope this helps.
Fons
 
Thank you! That did EXACTLY what I wanted it to do! I didn't even make a copy
of the report cause I had faith that it would work.
Thanks very much!

Fons Ponsioen said:
Melissa.
You could use a copy of your current report and create a grouping by date,
and create a footer for this group.
Now, in the date footer band insert an unbound textbox and insert:
=Sum([NumberOfHours])
Substitute the name of your hour field.
Hope this helps.
Fons

dogmelissa said:
I have a report set up which we use to schedule people's time. It currently
has fields which we type a number into for the "number of hours" allocated to
a job and this will show on the report. Our report is broken up on a daily
breakdown; for example, it would print that there are 5 jobs for today
November 5, and each one has 3 hours allocated. What I want to do is total
the number of hours we have scheduled in a day, on the report, and show this
in the section for that day. So today would show Total hours: 15. Does this
make sense?
Any suggestions on how to do this? I know it can be done, I'm just not sure
how.

Thanks in advance,
Melissa
Click to expand...
Click to expand...
 
Back
Top