Print reporting period on a report header

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have created a report based on a query that asks for
starting and end dates stored in one of the fields in the
table. (The report would be used for monthly reporting.)

The start and end dates are criteria in a lookup query.

How do I print the starting and end dates on the report
header?

I would like to get something like the following:

"Reporting dates June 1 2003 through June 30 2003" to
print on the header.

Any help would be appreciated.

Steve
 
Thanks

That worked well. Its so easy once you know the answer.

Steve
-----Original Message-----
Create a text box with a control source of
="Reporting dates " & [Enter Start Date] & " through " & [Enter End Date]

-- <TOZ> --
Duane Hookom
MS Access MVP


Steve said:
I have created a report based on a query that asks for
starting and end dates stored in one of the fields in the
table. (The report would be used for monthly reporting.)

The start and end dates are criteria in a lookup query.

How do I print the starting and end dates on the report
header?

I would like to get something like the following:

"Reporting dates June 1 2003 through June 30 2003" to
print on the header.

Any help would be appreciated.

Steve
Click to expand...


.
Click to expand...
 
Back
Top