how do I format the numbers in access to be XXX.XXX.XXX.XXX forma.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create an access database and I want to create a field that i
can put an IP address in this format XXX.XXX.XXX.XXX but I dont know how to
do that.
 
You could use a text field, as suggested elsewhere in this thread, or you
can use four integer fields for the four separate parts of the IP address,
and concatenate them as necessary. For example in a query the expression to
concatenate them would look something like this ...

IP: IPA & "." & IPB & "." & IPC & "." & IPD

.... where IPA, IPB, IPC and IPD are the names of the four fields.

The advantage of the four fields is that you can easily sort and filter and
use indexes on the IP address or any part of the IP address.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top