How to group the Ip addresses

[#1]

HI all

how to group the Ip addresses with the same numbers upto 3 octets

like 192.168.1.1

     192.168.1.2

     192.168.2.1

     192.168.2.3

     192.169..1

     192.169.3.3

from the above values in a column , I would like to display a list box with the values like

     192.168.1

     192.168.2

Thanks

[lakshmikandh]

You can use mid with index

mid(IPfield,0, index(IPfield,'. ', 2) + 1)

[sunny_talwar · Accepted solution]

I think more like this:

Mid('192.168.1.1', 1, Index('192.168.1.1', '.', 3) - 1)

or

Mid(IPAddress, 1, Index(IPAddress, '.', 3)-1) as GroupedID