Print the Start Date and End Date on the Title page of a report

[Ligaya]

Hello,
I have created a report which shows all the hours worked by employees over a week (between a date range). The report is like a timesheet.
I would like to have the start date and end date of the working week to print on the title page of the report (e.g. Start Date 6/06/07, End Date 12/06/07.
I am at a loss on how to do it. I would appreciate any help on how to go about it please.

Many thanks,
Ligaya

 

[rainman89]

How do you enter the date range that you want? is it from a form?

 

[Ligaya]

Date Range to show on report

Hello Ray,
All the dates worked by the employees are in a form, and I created a query with a criteria to pull out the data between a certain start date and end date. My report is based on the query. When I open the report, with the prompts, I type in the dates required and the timesheet for that period is then created. To make it convenient for the payroll ofice, I want the date range shown in the time sheet to print on the cover page so that they can tell at a glance which week it is that the timesheet report is based on.
Could you please help?
Regards,
Ligaya

 

[rainman89]

If you open the report from a form instead of typing into the prompts then it would be easier to transfer them onto the report like you want.

 

[Ligaya]

Print the Start and End dates on title page of a report

Hello Ray,

Thank you for your assistance. I shall certainly do as you suggested.

Regards,
Ligaya

 

[Ligaya]

Print Start Date an End Date on Title Page of Report

Success!

Thanks for your help, Ray. All's fine now.

Regards,
Ligaya

 

[rainman89]

Glad to help!!