Solved

How to use monthname function in report?

Posted on 2000-03-04
1
367 Views
Last Modified: 2012-06-21
I want my group header to display the month name in a report. I can't figure how to use the VB function monthname()-- it's not listed in my 'build' window.
What should I do?

TIA,..instanet

0
Comment
Question by:instanet
1 Comment
 
LVL 6

Accepted Solution

by:
bknouse earned 100 total points
ID: 2583961
I would just use the format function (I haven't heard of the monthname function).  The way to do this:

Variable: MyDate

Put into a textbox control MyDate as it's source.  Set it's format property to MMMM

The way it works;
MM returns 01, 02, 03, etc.
MMM returns Jan, Feb, Mar, etc.
MMMM returns January, February, March, etc.

Brent
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

821 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