|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 20th, 2010, 09:47 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Using Access 2003 convert numeric month to text for reports
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. 
|
|
#2
January 20th, 2010, 10:11 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Using Access 2003 convert numeric month to text for reports
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
|
|
#3
January 20th, 2010, 10:52 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Using Access 2003 convert numeric month to text for reports
On Jan 20, 3:11*pm, "Albert D. Kallal"
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 Perfect, Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
