How to adjust text in title based on last 2 numbers in one of the fields

[Russellh]

Instead of creating 12 reports (1 for each month of the year) how would have the "month" in the report header based on the last 2 numbers in one of the fields.
This field that I want to base it on will be in the format YYMM ex 1403 for march of 2014. So if the field reads 1403 I want it to say March if it says 1406 I want it to say June.



Unless there is a better way of doing this. Please let me know.

Russellh

[ItsMe]

Maybe something like this

Dim strValue As String
Dim strAnswer As String
strValue = 1403
strAnswer = MonthName((Mid(strValue, 3)))
MsgBox strAnswer

[Russellh]

Maybe something like this

Dim strValue As String
Dim strAnswer As String
strValue = 1403
strAnswer = MonthName((Mid(strValue, 3)))
MsgBox strAnswer

I apologize for this next dumb question. Where would I insert this code?

[ItsMe]

It is not dumb. Reports are not easy to apply variables to. If a field is available to the header section you could replace the string variable with the field and simply place an expression in an unbound text box in the header.

[ItsMe]

I was using my phone earlier.

Here is an example of an expression
= MonthName((Mid(Me![FieldName],3)))