Prev: Access 2007 Close button disappears..
Next: How can it go sideway year by Year ( TahunPel/Year Servie).
From: Loggical via AccessMonster.com on 23 Nov 2009 22:08
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1

From: Allen Browne on 24 Nov 2009 09:30
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Loggical via AccessMonster.com" <u28343(a)uwe> wrote in message
news:9f92d8941f12a(a)uwe...
> 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

From: John Spencer on 24 Nov 2009 10:31
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 wrote:
> 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.
>
From: Loggical via AccessMonster.com on 25 Nov 2009 03:04
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.


Allen Browne wrote:
>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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1

From: Allen Browne on 25 Nov 2009 03:35
Both dates on all pages?

You will need to use a list box or subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Loggical via AccessMonster.com" <u28343(a)uwe> wrote in message
news:9fa2016295302(a)uwe...
> 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.
>
>
> Allen Browne wrote:
>>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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1
>
 |  Next  |  Last
Pages: 1 2
Prev: Access 2007 Close button disappears..
Next: How can it go sideway year by Year ( TahunPel/Year Servie).