Convert Text Into Month

[zyus]

I hv text field as below

Month Yr
1 2008
2 2008
3 2008

How to capture the above record as a valid month & year say

Jan-2008
Feb-2008
May-2008

TQ

 

[Rui]

you could use the function MonthName as in:

result = MonthName([Month], True) & "-" & [Yr]

 

[Krzysztof Pozorek [MVP]]

(...)

Month Yr
1 2008
2 2008
3 2008

How to capture the above record as a valid month & year say

Jan-2008
Feb-2008
May-2008

In the query for example, you can write this:

SELECT Format(DateSerial([Yr],[Month],1),"mmm-yyyy") FROM Table1;

K.P.