Data conversion errors in update query 1

[vba317]

I am working in an access 2003 table. I have a field of data called MonDesc that is formatted as a string. The field has the month and year combined as one number. ex. 082010. I added another field called MonOnlyDesc that is formatted as a number. I am trying to run an update query that extracts the month from the field MonDesc and adds to to the field MonOnlyDesc. I get a dataconversion error when I do the update. Any help would be appreciated.

'Query in SQL view

UPDATE DICT_ImpMonList SET DICT_ImpMonList.MonOnlyDesc = Int(Left([MonDesc],3));

 

[PHV]

What about this ?
UPDATE DICT_ImpMonList SET MonOnlyDesc = Val(Left(Trim(Nz(MonDesc "00")),2))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vba317]

Thank you it works

 

[PHV]

Sorry for the typo: missing comma inside the Nz function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vba317]

No problem, I fixed it without thinking about it. Your help is so greatly appreciated that I didn't want to bother you with that.

Tom