Is there a function that will add zeros to the beginning of my data. I have
four fields that consist of the four octets for an IP address. I would like
to create a function that will pad each field with zeros if the field is less
than 3 numbers. Such as if the existing data is 1, I want it to change the
data to 001 or if the the data is 10, I want it to be 010. Also, if the data
is 0, I want it to be 000. I actually want the data to change, not just the
way it displays. I intend on importing this changed data into an Access
database. If there is a better way to do this, I am open to suggestions.
Thanks. Matt