MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

Number manipulations

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

Num2Num	Functions for converting numbers from one base to another. For example, Hex to Roman, Octal to Decimal, Binary to, well, you get the picture.
Num2Ord	Functions for converting numbers to their ordinal positions. For example, 1 to 1st, 224 to "two hundred and twenty fourth", "seventy five" to 75th.
Num2Text	Functions for converting numbers to their textual representation, including currency & distance. For example, 123.45 to "one hundred and twenty three dollars and forty five cents", 98.76 to ninety eight point seven six miles, and 543 to "five four three".
Bit Manipulations	Functions to set, toggle, clear or check the value of a specific bit