Making Month Names show in query reports

[jdboss53]

Hey all,

This is my first post and I am a huge novice. I acquired an Access DB for our business and it is very complex. I have been able to make minor changes here and there but am struggling. There are several Cross Tab Queries that report on volumes and referrals by month, quarter and year. On the reports though, they are reported as M3, M5 etc. I have seen the Format "MMMM" suggestion but have not gotten it to work. I've seen some other suggestions and in design view, I have tried to write conditions in the criteria tab and have either failed due to improper structure or the MMMM simply not working. Thoughts??

Thank you!

[andy49]

Do you mean how to get m3 to show up on a report as march? (3rd month)


Sent from my iPhone using Tapatalk

[ranman256]

make a table of tMonths
MoNum, Title
1, M1
2, M2
etc

join this table to your data query, join on Month([MyDate]) and you will get your proper titles for the report.

[jdboss53]

Yes sir I want the report to read march and not M3

[jdboss53]

I've created the table but I'm not understanding how to join it or write the expression. May I have detailed instructions?

[andy49]

An alternative might be change the field on the report which has M3 (I'll assume it is mymth.

Create a text box and type
Monthname(Mid([MyMth],2,Len([Mymth])))

This should return January etc


Sent from my iPhone using Tapatalk

[jdboss53]

Thanks for the tip andy49 but it's not a report. It's a cross tab query that auto generates a graph with volumes. I want the M3 etc on the graph to say January, feb, etc.

[andy49]

The sql might prove useful here of the cross tab query


Sent from my iPhone using Tapatalk