Update Query: Convert numeric month to only relfect Month name

[Fuzz_cozens]

Morning Experts,



I import an excel file weekly into my DB and would like to use an update query to update 2 columns in the Table [Policy Information]. The 2 columns in the excel I import are called [Policy Month] and [Policy Year]

Ecxel Table is called Extract
DB Table to Update is called Policy Information

These 2 columns are displayed as follows:

Policy Month: 6
Policy Year: 2014

All I would like to do is to update this to "1 June". The policy year is fine as is however I would like to join these 2 columns into a new column for the end result of "1 June 2014"

I have tried DatePart("m",[production month]) and Dateserial without luck as these only return values of Jan or Dec.

I am using Access 2010 and Win 8

Thanks in advance

Richard

[alansidman]

In an expression in a new column Policy Date: 1 & " " & DatePart("m",[production month]) & " " & [Policy Year]

[Fuzz_cozens]

Thanks pal. Will try quickly

[Fuzz_cozens]

Thanks Alansidman

I used the expression you gave and the result is reflecting "11 2013" which is obviously for November 2013.

There are 2 hassles here:

Firstly it is reflecting 11 for the month for all 28,000 records and obviously there are a lot of records with different months of the year.
Secondly, I would like the word "November" to be used and not the numerical 11

If I look at the table properties of the extract file the 2 fields [Production month] & [Policy Year] are both in data format number and general Number format. What format should these 2 fileds be. I would think date (med) Any ideas

Rich

[lfpm062010]

To show the full month name use this,

Policy Date: "1 " & Monthname([production month]) & " " & [Policy Year]

[Fuzz_cozens]

Works perfectly. Thanks very much.