Prev: How to create a report border that changes color w/each new secti
Next: Printing a large report in 30 page groups?
From: M G Henry on 20 Jan 2010 16:47
Hello everyone,

Looking for a way to create a report using data that has dates
formated as 01/01/2003 ( basically mm/dd/yyyy ) but want to display
on the report sorted under categories ( using a query to sort the
categories ) but printed out as long version of the month. January
2005 etc.

Thanks for the help.
From: Albert D. Kallal on 20 Jan 2010 17:11
You can place a text box on the report based on the date column (call the
text box txtMonth or some such).

the text box can be formatted as:

=(Format([DateCollum],"MMMM, YYYY"))

the above would show

January, 2005

for today's date....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal(a)msn.com


From: M G Henry on 20 Jan 2010 17:52
On Jan 20, 3:11 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...(a)msn.com>
wrote:
> You can place a text box on the report based on the date column (call the
> text box txtMonth or some such).
>
> the text box can be formatted as:
>
> =(Format([DateCollum],"MMMM, YYYY"))
>
> the above would show
>
> January, 2005
>
> for today's date....
>
> --
> Albert D. Kallal    (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKal...(a)msn.com

Perfect, Thanks.
 | 
Pages: 1
Prev: How to create a report border that changes color w/each new secti
Next: Printing a large report in 30 page groups?