Condensing information in reports

  • Thread starter Thread starter soucydm
  • Start date Start date
S

soucydm

I am using the Time Card database template and I am trying to create a report
by project that will provide total hours for a week without listing each day
that all employees worked. How can I sumarize the report to just show a week
number instead of a long list of dates?
 
I'm not familiar with the template, but I assume the report includes a group
footer which aggregates the times. If so set the Visible property of the
report's Detail section to False ('No' in its properties sheet). Only the
footer with the aggregated values will then show.

Ken Sheridan
Stafford, England
 
I am using the Time Card database template and I am trying to create a report
by project that will provide total hours for a week without listing each day
that all employees worked. How can I sumarize the report to just show a week
number instead of a long list of dates?
Click to expand...

Put a calculated field in the query such as:

WeekNo: DateDiff("ww", DateSerial(Year(Date()), 1, 1), [datefield])

This field will contain the week number (1 to 52 or 53 or 54 depending on the
year), and can be used for grouping in your report.
 
Back
Top