Storing IP Addresses in Microsoft Access, Prevent Duplicates, Sort Numerically
In this Microsoft Access tutorial, I will teach you how to properly store IP addresses. I will show you how to prevent duplicate values yet also how to sort the list numerically. I'm going to show you two different ways to accomplish this. In the first video will split the IP address up into four separate fields and then in the extended cut for the members we'll store it as a single text field and split it up with functions.
Dan from Sacramento, California (a Gold Member) asks: I need to have a list of IP addresses that is searchable. I cannot have duplicate values. If I split the IP address into 4 separate fields, then I can't use Indexed (No Duplicates). If I enter the full IP address as a text field, then the sort is wrong (192.168.1.100 comes before 192.168.1.2). What is the best way to accomplish this?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to store the IP address in a single text field and use the split function to break it up into its four component values.
MEMBERS VIDEO:
• IP Addresses MEMBERS ONLY EXTENDED CU...
BECOME A MEMBER:
YouTube: / @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/IPAddresses
PRE-REQUISITES:
Composite Key: https://599cd.com/CompositeKey
LINKS:
Split Function: https://599cd.com/SplitFunction
RECOMMENDED COURSES:
Access Developer 1: https://599cd.com/ACD1
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: / learningaccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, how to properly store IP addresses in Microsoft Access, split IP address, sort IP addresses
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.