Print Parameter Date range on Report Header

[FA]

Hi Freinds i have a report based on the query where the parameters are
STAT_DATE
Between Date()-7 And Date()

I want the dates to appear in the report header.

Can it be possible?

Your suggestion would be greately appreciated.

Thanks
Moe

 

[fredg]

Hi Freinds i have a report based on the query where the parameters are
STAT_DATE
Between Date()-7 And Date()

I want the dates to appear in the report header.

Can it be possible?

Your suggestion would be greately appreciated.

Thanks
Moe

If the parameters are fixed at Date()-7 and Date(), simply use that
same expression in the report header:

="For Sales between " & Date()-7 & " and " & Date()

However, if you wish to make the report more useful, use a parameter
within the query so that the user can enter the wanted dates, i.e.
Between [Enter Start Date] and [Enter End Date]

Now in the report header you would write:
="For Sales between " & [Enter Start Date] & " and " & [Enter End
Date]

Whatever dates were entered in the query when prompted will appear in
the report header.

 

[Guest]

I have a similar question. My form using two different text boxes so the
user will input two different dates. This will be the date range for the
query. This will run the parameter query with the criteria of:

Between [forms]![frmAllGeneralCases]![Op_Date] And
[forms]![frmAllGeneralCases]![Discharge_Date]

How do I set up my report header so the two dates I enter in the form are
then printed on the report?

Many thanks.

Kim

Hi Freinds i have a report based on the query where the parameters are
STAT_DATE
Between Date()-7 And Date()

I want the dates to appear in the report header.

Can it be possible?

Your suggestion would be greately appreciated.

Thanks
Moe

If the parameters are fixed at Date()-7 and Date(), simply use that
same expression in the report header:

="For Sales between " & Date()-7 & " and " & Date()

However, if you wish to make the report more useful, use a parameter
within the query so that the user can enter the wanted dates, i.e.
Between [Enter Start Date] and [Enter End Date]

Now in the report header you would write:
="For Sales between " & [Enter Start Date] & " and " & [Enter End
Date]

Whatever dates were entered in the query when prompted will appear in
the report header.

 

[fredg]

I have a similar question. My form using two different text boxes so the
user will input two different dates. This will be the date range for the
query. This will run the parameter query with the criteria of:

Between [forms]![frmAllGeneralCases]![Op_Date] And
[forms]![frmAllGeneralCases]![Discharge_Date]

How do I set up my report header so the two dates I enter in the form are
then printed on the report?

Many thanks.

Kim

Hi Freinds i have a report based on the query where the parameters are
STAT_DATE
Between Date()-7 And Date()

I want the dates to appear in the report header.

Can it be possible?

Your suggestion would be greately appreciated.

Thanks
Moe

If the parameters are fixed at Date()-7 and Date(), simply use that
same expression in the report header:

="For Sales between " & Date()-7 & " and " & Date()

However, if you wish to make the report more useful, use a parameter
within the query so that the user can enter the wanted dates, i.e.
Between [Enter Start Date] and [Enter End Date]

Now in the report header you would write:
="For Sales between " & [Enter Start Date] & " and " & [Enter End
Date]

Whatever dates were entered in the query when prompted will appear in
the report header.

Add an unbound control to the header.
Set it's control source to:

="For sales between " & [forms]![frmAllGeneralCases]![Op_Date] & "
And " & [forms]![frmAllGeneralCases]![Discharge_Date]