[AccessD] Rounding in SQL Server ODBC

Gustav did not want to use a "custom external function", i.e. one defined in
a VBA module. Choose() (and Mod() and Sgn()) are all implemented in the
various DLLs that go to make up Access and consequently run a lot faster
than custom functions.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, May 02, 2006 4:19 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Rounding in SQL Server ODBC


On 2 May 2006 at 15:39, Gustav Brock wrote:

> Hi Stuart
> 
> Thanks! That could do it.
> I wish to avoid a custom external function but had forgotten Choose()
which
> is external though not custom.
> 

What do you mean by "external"?  How does Choose() differ from Mod, Sgn(), 
IIf() etc?


-- 
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com