Format month number as text in text box returns only January

R

RDResearch

I have a report that is pulling information from a select query that is using
grouped fields. In the query I have data sorted by the following two
expressions Year: datepart("yyyy",[date sent]) and Month:
datepart("m",[date sent]). In the report, Year is a group header followed by
Month as a group header. I want to create a text box under month to read
"monthname, year". In the text box I have =Format("mmmm",[month])&",
"&([year]). This returns "January 2006" for each month (2006 is the only
year involved for now). I dealt with a similar problem several years ago and
I no longer have that database with the fix. Thank you to anyone who can
help.
 

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

Creating a Search using a combo box and then creating a report. 4
Multi-level GROUP BY 8
Format Function in Expression Builder 1
Text Header displaying incorrect information 2
Change a great number of words in word files, with a macro as short as possible. 5
Loop Macro to edit Date 0
Month in title of monthly report 4
year and month wrong 1

Top