If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Control showing span by year
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. |
#3
|
|||
|
|||
Control showing span by year
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. . |
#4
|
|||
|
|||
Control showing span by year
="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. . |
Thread Tools | |
Display Modes | |
|
|