sir
I have created a database in ms-access.Connected database using ADODB
I have written a query to round integer to nearest value such as
con.execute"update tablename set fieldname1=round(fieldname1,2) where fieldname2='........' ".
when i directly excute this query in access round funtion works.But when i use this round function through visual basic it shows me an error message such that "undefined round function"
please give me suggestion how to round number to nearest integer value . And must be executed through visual basic.
thanking you
kind regards
c.prakash