[AccessD] Rounding in SQL Server ODBC

Stuart McLachlan stuart at lexacorp.com.pg
Tue May 2 05:51:37 CDT 2006


On 2 May 2006 at 9:42, Gustav Brock wrote:

> Hi Scott
> 
> Well, it could be, and I considered some IIf() constructs too, but they got
> too long-winded. 

How about:
(ID \ 10) * 10 + Choose(ID Mod 10 + 1, 0, 0, 3, 3, 3, 7, 7, 7, 7,10)

-- 
Stuart





More information about the AccessD mailing list