471,066 Members | 993 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

round query


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
Oct 7 '06 #1
0 1771

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Matias Silva | last post: by
10 posts views Thread by Henrootje | last post: by
3 posts views Thread by Arie | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.