Control showing span by year

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

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?
 
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.
 
="THIS REPORT SPANS: " & Year(Min([DateField])) & " - " &
Year(Max([DateField]))

--
Duane Hookom
MS Access MVP


DD said:
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





.
Click to expand...
Click to expand...
 
Back
Top