Show Date Range in Report Header

[Jatinbhayana]

I have a small problem. I have a report based on a query which requires the user to input the date range. I would like this date range to be a label in the report header. Could someone please help me the formula?which shows both the date and time an entry was made.

For the previous reports I would run Yearly reports Display the Day ,month and year entered in a parameter query

At present I am trying to run a report for the period "Jan 1 2010 to Dec 31 2010" and would like a formula that would display "Jan 1 2010 to Dec 31 2010" in the report header.

SELECT GetAutonumber([CountryName]) AS [No], ProjectDetails.ProjectName, FundingInstitution.FundingInstitution, EOIDetails.ClientAddress, EOIDetails.DateOfSubmission, EOIDetails.ConsortiumName, EOIDetails.ProgressStatus
FROM ((FundingInstitution INNER JOIN (ClientMaster INNER JOIN ProjectDetails ON ClientMaster.ClientID = ProjectDetails.ClientID) ON FundingInstitution.FundingInstitutionID = ProjectDetails.FundingInstitutionID) INNER JOIN EOIDetails ON ProjectDetails.ProjectID = EOIDetails.ProjectID) INNER JOIN (CountryMaster INNER JOIN ProjectCountry ON CountryMaster.CountryID = ProjectCountry.CountryID) ON ProjectDetails.ProjectID = ProjectCountry.ProjectID
WHERE (((EOIDetails.DateOfSubmission) Between [StartDate] And [EndDate]) AND ((CountryMaster.CountryName)=[Forms]![CountryMaster]![CountryName]))
ORDER BY EOIDetails.DateOfSubmission;

[Rabbit]

You'll have to create a form the parameters and then reference the form controls in the report.

[Jatinbhayana]

thanks Rabbit
but i wanna to Store the parameters values in header like(Start date And End date)

[Rabbit]

Yes I know. You have to create a form for that. You can't reference the query parameters so you have to use an intermediary, i.e. the form.

[Jatinbhayana]

ok rabbit thanks for ur help