Hai All,

I try to get recordset from access table like month as number by using TO_NUMBER but did not work
qqqry = "SELECT ID,TO_NUMBER(format(date," & Chr(34) & "mm" & Chr(34) & ")) AS mymonth FROM date_test"
rs.Open qqqry, db, adOpenStatic, adLockReadOnly
error occurs "UNdefined function 'TO_NUMBER' in expression

how can i solve it

please help