Undefined function 'Round' in expression

[er13b6ac]

I am building an sql statement, that includes the 'Round' function, to send a query to an Access database. When I try and open the ADODB.Recordset with the sql statement, I get:

Error![Microsoft][ODBC Microsoft Access Driver]Undefined function 'Round' in expression.

The sql statement works correctly when I load it directly into the Access SQL view. I assume I am missing a library. How do I find out what library is needed?

VB6/Access 2000/NT 4.0

 

[DonQuichote]

You're not missing a library, but MS-Access supports VBA and user-defined functions. When you run the query without MS-Access, these functions will not run. So if you use ADO without running Access, you'll have to stick with pure SQL.