How do I get a month's name to print on a report instead of a #?

J

JourJay

In my Access database I have a birthday field named DOB which is formatted as
mm/dd/yyyy (i.e. 01/05/2005. I created a query to separate the birthdays
stored into the month, day, and year using the following expression for the
month section - Expr1: Month([DOB]) so I could sort and prinout the birthdays
by month on a report. My question is this... How do I get the actual name
of the month to show up on the report instead of the number? (I want January
or JAN instead of 1 to print on the report.) I have tried everything
including variations with the MonthName function and can't get it to work.
Any solutions out there?
 
J

Jeff Boyce

Without "extracting" the month, consider using something like the following
to modify the format of display, not the underlying data:

Format([YourDOB],"mmmm")

(your syntax may vary).

Good luck

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top