Print Parameter Date range on Report Header

  • Thread starter Thread starter FA
  • Start date Start date
F

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
 
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
Click to expand...

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.
 
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

fredg said:
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
Click to expand...

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.
Click to expand...
 
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

fredg said:
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
Click to expand...

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.
Click to expand...
Click to expand...

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]
 
Back
Top