>Is there is a function in Access 97 that would allow me to round up number to a specific decimal, in this case the decimal before the last one.
>
>eg. 11,5 to 12
> 11,567 to 11,57
> 15,66609 to 15,6661
> and so on...
Something like this: format(15.66609 ,"#####0.0000")
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com