Reports

[Malt via AccessMonster.com]

Hi,

I have a report that has a Start date and an End date text box in the header
which have their data coming from a parameter query. I need to display the
full date, ie. August 1, 2007, in each text box. There is also a Date label
on the left side of this line and a to label between the text boxes. I have
set the Start date to right aligned and the End date to left aligned. This
causes a gap between the Date label and the Start date text when the month is
less than September. Is there any way to avoid this gap without causing a gap
on either side of the to label??

Date: April 1, 2006 to March 31, 2007
Date: September 1, 2006 to August 31, 2007

 

[Duane Hookom]

You can combine them into one control source:
=Format([Start Date],"mmmm d, yyyy") & " to " & Format([End Date],"mmmm d,
yyyy")

IMHO, replace parameter prompts with references to controls on forms.

 

[Malt via AccessMonster.com]

Great! Thanks, Duane

You can combine them into one control source:
=Format([Start Date],"mmmm d, yyyy") & " to " & Format([End Date],"mmmm d,
yyyy")

IMHO, replace parameter prompts with references to controls on forms.

Hi,

[quoted text clipped - 9 lines]

Date: April 1, 2006 to March 31, 2007
Date: September 1, 2006 to August 31, 2007