Condensing information in reports

[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?

 

[Ken Sheridan]

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

 

[John W. Vinson]

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?

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.

 

[soucydm]

Thank you so much, I cannot believe I am that dim!!!