Month date format capitalized

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

"PROMO_START_DATE" (looks like 7/14/2005) is used to create another field
called "MONTH" in my forms, queries, and reports. I have "MONTH" displayed
as a 3-letters using the "mmm" format. Problem is boss wants everything
capitalized for reporting. How do I get "Jul" to appear as "JUL" in my
forms, queries, and reports?

Thank you in advance
 
There might be an easier way, but you could use...

=UCase(Format([PROMO_START_DATE],"mmm"))
 
Use a calculated field in your query that has an expression similar to this:
CapsMonth: UCase([MONTH])

By the way, using MONTH as a field name or a control name is not
recommended. See these Knowledge Base articles for more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
 
Back
Top