Report Headers

M

Moo

I have a report that shows sales for the year, sorted by month. So the date
is grouped on month, and has a separate page for each month. How can I
create a label in the header of each page that will tell for what month it's
reporting. ie: on the first page will be January sales in the format
01/01/05. I want header to say January sales...
 
R

Rick B

add a page (or group) header and put something like the following in an
unbound text box...

=Format([YourDateFieldNameHere],"MMMM")



Or...


= "Report for the month of: "& Format([YourDateFieldNameHere],"MMMM")


Hope that helps,
Rick B
 
F

fredg

I have a report that shows sales for the year, sorted by month. So the date
is grouped on month, and has a separate page for each month. How can I
create a label in the header of each page that will tell for what month it's
reporting. ie: on the first page will be January sales in the format
01/01/05. I want header to say January sales...
Click to expand...

As long as the report is forcing a new page for each month, simply add
an unbound text control to the Page Header:
=Format([DateField],"mmmm") & " Sales"

As the page header has access to the first detail record, whatever the
first detail record's date for the month is will be displayed in the
header.
 
Top