sir
I have created a database in ms-access.Connecte d database using ADODB
I have written a query to round integer to nearest value such as
con.execute"upd ate tablename set fieldname1=roun d(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
I have created a database in ms-access.Connecte d database using ADODB
I have written a query to round integer to nearest value such as
con.execute"upd ate tablename set fieldname1=roun d(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