Control showing span by year

I have a report which shows what projects employees log
their time to daily. For example, Emp. #445, Project #:
22334, Date: 2/4/04, Time: 5.5 Hours. Sometime we run a
report consisting My report is grouped by project number
and then all of the time each employee logs is under it.
At times we run a yearly report. Other times we run a span
of five years. What I need in the header is a control
which shows only the year(s) the report consists of based
upon the dates: for example THIS REPORT SPANS: 1990 -
2000. Thanks in advance.

This depends on how you are specifying/filtering the report years. Can you
tell us how a user runs the report for a year or span of five years?

--
Duane Hookom
MS Access MVP


"DD" wrote in message
...
I have a report which shows what projects employees log
their time to daily. For example, Emp. #445, Project #:
22334, Date: 2/4/04, Time: 5.5 Hours. Sometime we run a
report consisting My report is grouped by project number
and then all of the time each employee logs is under it.
At times we run a yearly report. Other times we run a span
of five years. What I need in the header is a control
which shows only the year(s) the report consists of based
upon the dates: for example THIS REPORT SPANS: 1990 -
2000. Thanks in advance.

The report is run from a query by form - the underlying
query includes the date the employee logged time to the
project. And I have a calculated control next to each
project which shows the entire span of the time logged:
Here is that control: =(Min([Date])) & " to " & (Max
([Date])). I'd like to do the same thing but only show
date with just the years showing for minimum and maximum.

-----Original Message-----
This depends on how you are specifying/filtering the
report years. Can you
tell us how a user runs the report for a year or span of
five years?

--
Duane Hookom
MS Access MVP


"DD" wrote in
message
...
I have a report which shows what projects employees log
their time to daily. For example, Emp. #445, Project #:
22334, Date: 2/4/04, Time: 5.5 Hours. Sometime we run a
report consisting My report is grouped by project number
and then all of the time each employee logs is under it.
At times we run a yearly report. Other times we run a
span
of five years. What I need in the header is a control
which shows only the year(s) the report consists of
based
upon the dates: for example THIS REPORT SPANS: 1990 -
2000. Thanks in advance.


.

="THIS REPORT SPANS: " & Year(Min([DateField])) & " - " &
Year(Max([DateField]))

--
Duane Hookom
MS Access MVP


"DD" wrote in message
...
The report is run from a query by form - the underlying
query includes the date the employee logged time to the
project. And I have a calculated control next to each
project which shows the entire span of the time logged:
Here is that control: =(Min([Date])) & " to " & (Max
([Date])). I'd like to do the same thing but only show
date with just the years showing for minimum and maximum.

-----Original Message-----
This depends on how you are specifying/filtering the
report years. Can you
tell us how a user runs the report for a year or span of
five years?

--
Duane Hookom
MS Access MVP


"DD" wrote in
message
...
I have a report which shows what projects employees log
their time to daily. For example, Emp. #445, Project #:
22334, Date: 2/4/04, Time: 5.5 Hours. Sometime we run a
report consisting My report is grouped by project number
and then all of the time each employee logs is under it.
At times we run a yearly report. Other times we run a
span
of five years. What I need in the header is a control
which shows only the year(s) the report consists of
based
upon the dates: for example THIS REPORT SPANS: 1990 -
2000. Thanks in advance.


.