date conversion

J

John

How do you convert a month number into the month word? I
have a report that prompts the user for the month number
and then returns the data for that month. I want to put a
label at the top of the report that shows what month that
data is for. Example:

User enters: 8
Report shows data for August
When the user enters: 8
I want the report to return the word "August" in a label
field on the report.

TIA,

John
 
R

Ron Dyson

-----Original Message-----
How do you convert a month number into the month word? I
have a report that prompts the user for the month number
and then returns the data for that month. I want to put a
label at the top of the report that shows what month that
data is for. Example:

User enters: 8
Report shows data for August
When the user enters: 8
I want the report to return the word "August" in a label
field on the report.

TIA,

John
.
Click to expand...
 

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

Similar Threads

ASK Field Formatting 1
Sorting an Access report by month 5
MTD Total as of Date Filtered 8
Selecting Date Range in a Pivot using VBA 0
Sorting/Grouping question on report 2
Summary Report 2
Multi-month data strategy 2
Excel does not accept text format! 0

Top