Format month number as text in text box returns only January

G

Guest

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

Multi-level GROUP BY 6
Text Header displaying incorrect information 2
Format Function in Expression Builder 1
Filtering by Month 1
year and month wrong 1
Access 2 Digit year in Access Text Box 3
Date in the text format. 2
Empty date field error 10

Top