Tagged with " database"
Jan 27, 2006 - Geeky General    Comments Off on Sort IP addresses in an MS Access database

Sort IP addresses in an MS Access database

If you work with IP addresses, you probably already know that it is not as straightforward as working with text or numbers. This is because an IP address is really a collection of four numeric values separated by a period (.), where each value is a number between 0 and 255.

The reason IP addresses are challenging to work with is that Access does not provide a special data type for storing IP addresses. And even though the address is just a collection of numbers, you cannot store the addresses in a numeric field. This is because a numeric field supports only a single decimal point (.), whereas an IP address contains three periods (.). This leaves you with only the option of storing the addresses in a text field. Read more »