[AccessD] masking question

Neal Kling nkling at co.montgomery.ny.us
Tue Feb 8 13:27:04 CST 2005


Here's the one I use.

###.###.###.###;0;_

Neal

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
Sent: Tuesday, February 08, 2005 2:15 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] masking question


This is probably an Access 101 question, but I don't get it.

I was trying to whip up a quick database to track all of our network
equipment. I basically want to track our servers, switches, and routers.
One of the fields is for the IP number of the item. I wanted to enter in
the form of 255.255.255.255 but I am having some difficulty, which
this...what I thought to be...simple task.

I am using a mask of "009.009.009.009" but if I don't use up the
spaces, I get "10 .10 .133.  3" and I want it to look like
"10.10.133.3"

What I think I have to do, and have proceeded that way, is to make the
mask "CCCCCCCCCCCCCCC" and input the "."s myself. This isn't the end of
the world...it is just something we'll be using in-house...but I was
just curious as to a work around.

Thanks 

John Clark
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list