Printing two different dates in a report

[Loggical via AccessMonster.com]

I have a Date field on my report that shows the date on the first page of the
report. The report can be several pages long with a date span of two days.
How can I get it so show both days in the header of the report, as in below?

Monday, November 23, 2009 – Tuesday, November 24, 2009


Thanks in advance.

 

[Allen Browne]

1. Create a group header on your date field.

2. Put the date in this section instead of the Page Header.

3. Set the section's Repeat Section property to Yes, so it repeats at the
top of each subsequent page.

 

[John Spencer]

Try setting the control's source to

=Format(Min(TheDateField),"Long Date") & " - " &
Format(Max(TheDateField),"Long Date")

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Loggical via AccessMonster.com]

The expression John Spencer gave works in the Report Header only.

I tried the method you advised with the JS expression but it only shows the
first date. I want both dates on all pages if possible.

Thanks again.

1. Create a group header on your date field.

2. Put the date in this section instead of the Page Header.

3. Set the section's Repeat Section property to Yes, so it repeats at the
top of each subsequent page.

I have a Date field on my report that shows the date on the first page of
the

[quoted text clipped - 3 lines]

Monday, November 23, 2009 – Tuesday, November 24, 2009

 

[Allen Browne]

Both dates on all pages?

You will need to use a list box or subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

The expression John Spencer gave works in the Report Header only.

I tried the method you advised with the JS expression but it only shows
the
first date. I want both dates on all pages if possible.

Thanks again.

1. Create a group header on your date field.

2. Put the date in this section instead of the Page Header.

3. Set the section's Repeat Section property to Yes, so it repeats at the
top of each subsequent page.

I have a Date field on my report that shows the date on the first page
of
the

[quoted text clipped - 3 lines]

Monday, November 23, 2009 – Tuesday, November 24, 2009

 

[John Spencer]

You can use the expression on each page in the Page Header or

Create a top-level group based on the expression =1
Add a control to this top-level group
Set the control's control source to the
= The expression I posted
Set the Top-level group's Repeat Section property to Yes (True) so that it
will repeat on every page.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Loggical via AccessMonster.com]

I put the expression in the Report Header, made its property invisible. Put a
Text box in the Date Header and set its property to the invisible expression.
Works exactly they way I want.

Many thanks for all your help.