[AccessD] Rounding in SQL Server ODBC

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.

>>> stuart at lexacorp.com.pg 02-05-2006 12:51:37 >>>
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