Im using an ado connection to an access 2000 database using the jet 4 as my provider. I would like to ask as why is the round function not supported when creating an sql-statement? The round function is working inside the query of an access database but why not when passing an sql-statement thru ado connection?
