Solved

How print month name using date on a report

Posted on 2014-01-15
2
770 Views
Last Modified: 2014-01-15
I am trying to print the name of the month using a date on a report.  So if for example the date on the report is 6/20/2014 then I want a field to show "June".

How?
0
Comment
Question by:SteveL13
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 39782390
=format(#6/20/2014#,"mmmm")

=format(DateField,"mmmm")
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 250 total points
ID: 39782406
For a lot of my reports, I like to put the month in the reports title, which is a label.

To do so, I use the Report_Open event, something like:

Private Sub Report_Open

    me.lbl_Title.Caption = "Some Report Name (" & Format(date(), "mmmm") & ")"

    'or for month year
    'me.lbl_Title.Caption = "Some Report Name (" & Format(date(), "mmm yy") & ")"

End Sub
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question