Prompt date popping up twice

[SalVOM]

Hi, needed my "date range" to print on the report hearder section which identifies the data that was selected. The date and all the data appears correctly. However, the Prompt "To" field pops up 2x's how do I get the propmpt "To" value to only prompt once?




Report header :

Productivity Reg Hours Worked by Date Range
From: 01/01/2014 - 01/31/2014Employee #: Employee Name:
601 Schafernak, Paul Total Actual Hours: 158.75

Date Prompt label is properties are:

=[Reports]![Productivity Reg Hours Worked by Date Range]![DateWorked From] & " " & " - " & " " & [DateWorked TO]

Thanks.

[June7]

Reference a textbox on form, the way you are for DateWorkedFrom.

[SalVOM]

Sorry, I not understanding!? That fields is set up as a textbox:

[June7]

Sorry, I now see the reference is Reports not Forms.

So that confuses me more. How does the From date get into the report data?

[SalVOM]

I created this report base off one of the queries that pulls daat based on the prompting for a date range (from - to) date. So i created a text field in the header sections and entered the following:

=[Reports]![Productivity Reg Hours Worked by Date Range]![DateWorked From] & " " & " - " & " " & [DateWorked TO]

The prompt for the "from" date shows up only once but the for the "to" range it pops up 2x's, so i enterer it twice and it only displays once.

[June7]

If this done properly there should be no popups.

That expression looks to the report for the DateWorkedFrom and DateWorkedTo values.

If the DateWorkedFrom and DateWorkedTo are entered on a form then the report must reference the form controls for the values.