Pls see this link: remove trailing zeros .

You may define a function and passing your recordset into that. Again there is no such straightforward function you can use.