Print reporting period on a report header

[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

 

[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

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

.