| From: | Tony Rolfe |
| Date: | 21 Sep 99 at 04:44:39 |
| Subject: | Re: Rounding amounts (fwd) |
On Mon, 20 Sep 1999 22:09:08 +0300 Sami N��t�nen said:
>
> Well I think I have the best solution for this particular case
>
> cents.l=(cents.l+2)/5*5
>
> and voila it's done. :)
Hmmm, even better than Paul's version.
And very much better than my original idea
SELECT VAL(Right$(UStr$(Cents),1))
CASE 1 ... etc
Thanks Sami
---------------------------------------------------------------------
To unsubscribe, e-mail: blitz-list-unsubscribe@netsoc.ucd.ie
For additional commands, e-mail: blitz-list-help@netsoc.ucd.ie