Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
IP address as data type
Great suggestion!!! The major problem i see with that is the size of the numbers will vary for example: 10.0.10.1 - 10.0.255.255 stripped it would be 100101 - 100255255 Is there a way to insert zeros before the number if the number is less than 3? Then it would be 01000000100001 -...- kerlawk
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
IP address as data type
i'm looking to import a large amount of data from an excel spreadsheet, where one of the columns is an ip range ie: 255.255.255.0 - 255.255.255.255 i would like to be able to sett up a query to search this range to see if a particular ip falls within this range, and if so diplay the correct...- kerlawk
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
