Report Header Text From Query

[Guest]

I have a report that is populated from a query, I use a form to query for the
start date and end date.
(Between [Forms]![frmViewRpt]![StartDate] And [Forms]![frmViewRpt]![EndDate]
I like to add to the report header the start date and end date.
(7/16/2007 to 7/31/07)
I cannot get any thing I have tried to work for me. Does anyone have a
suggestion?

 

[fredg]

I have a report that is populated from a query, I use a form to query for the
start date and end date.
(Between [Forms]![frmViewRpt]![StartDate] And [Forms]![frmViewRpt]![EndDate]
I like to add to the report header the start date and end date.
(7/16/2007 to 7/31/07)
I cannot get any thing I have tried to work for me. Does anyone have a
suggestion?

In an unbound control in the report header:
="For sales between " & Forms!frmViewRpt!StartDate & " And " &
Forms!frmViewRpt!EndDate

If you wish the date formatted in a certain way, i.e. "March 1, 2006"
then use:
& Format(forms!frmViewReport!StartDate,"mmmm d, yyyy")
etc...

Note: the form must still be open when the report is run.

 

[Guest]

Thanks Fred that is what I was looking for.

I have a report that is populated from a query, I use a form to query for the
start date and end date.
(Between [Forms]![frmViewRpt]![StartDate] And [Forms]![frmViewRpt]![EndDate]
I like to add to the report header the start date and end date.
(7/16/2007 to 7/31/07)
I cannot get any thing I have tried to work for me. Does anyone have a
suggestion?

In an unbound control in the report header:
="For sales between " & Forms!frmViewRpt!StartDate & " And " &
Forms!frmViewRpt!EndDate

If you wish the date formatted in a certain way, i.e. "March 1, 2006"
then use:
& Format(forms!frmViewReport!StartDate,"mmmm d, yyyy")
etc...

Note: the form must still be open when the report is run.