OT:Spell Month Blank Title 64709

Yahoo Archive
1
If you have a date, you can format the date as "mmmm", or if you really want the name of the month, you can use FORMAT([date],"mmmm"). If all you have is the month number, I use CHOOSE([month #], "January","February", ... , "December")

Thom Rose
Controller
Electric Mirror, LLC
T 425 776-4946 ext. 1024
F 425 491-8200
A 11831 Beverly Park Road, Building D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com/>
Note: The information contained in this e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use. www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jasper Recto
Sent: Friday, May 09, 2008 10:52 AM
To: Vantage Groups (E-mail)
Subject: {Disarmed} [Vantage] OT:Spell Month


In report builder there is a spell month feature that will take the month number and convert it to the name of the month.

Does anybody know if this is possible to do in Microsoft Access?

Thanks,
Jasper

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
In report builder there is a spell month feature that will take the month number and convert it to the name of the month.

Does anybody know if this is possible to do in Microsoft Access?

Thanks,
Jasper



[Non-text portions of this message have been removed]
3
Look at these two vb functions



DatePart(interval, date[,firstdayofweek[, firstweekofyear]])



MonthName(month[, abbreviate])





Mark

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Friday, May 09, 2008 1:52 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] OT:Spell Month



In report builder there is a spell month feature that will take the
month number and convert it to the name of the month.

Does anybody know if this is possible to do in Microsoft Access?

Thanks,
Jasper

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
What version do you need to have for this function? I'm on version 2000.

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Dupuis, Mark
Sent: Friday, May 09, 2008 2:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT:Spell Month



Look at these two vb functions

DatePart(interval, date[,firstdayofweek[, firstweekofyear]])

MonthName(month[, abbreviate])

Mark

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Friday, May 09, 2008 1:52 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] OT:Spell Month

In report builder there is a spell month feature that will take the
month number and convert it to the name of the month.

Does anybody know if this is possible to do in Microsoft Access?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
5
Open a table in design mode and you should find these in the expression
builder as built in functions. I'm sure you can get to these functions
when working with forms, I just haven't used access in 10+ years so I
don't remember how. These are standard visual basic functions that you
can access using Word, Excel or Access.



HTH

Mark



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Friday, May 09, 2008 2:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: RE: [Vantage] OT:Spell Month



What version do you need to have for this function? I'm on version 2000.

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Dupuis, Mark
Sent: Friday, May 09, 2008 2:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OT:Spell Month

Look at these two vb functions

DatePart(interval, date[,firstdayofweek[, firstweekofyear]])

MonthName(month[, abbreviate])

Mark

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Jasper Recto
Sent: Friday, May 09, 2008 1:52 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] OT:Spell Month

In report builder there is a spell month feature that will take the
month number and convert it to the name of the month.

Does anybody know if this is possible to do in Microsoft Access?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]