Recent content by Chirs Medico

I'm planning on doing that very thing. This was more of a first draft to make sure it was working. :) Chris

Yea, That part is just fine. The problem comes in when you have multiple blocks of "unassigned" or other like described IP addresses. Access groups all of them together even if they are not contiguous. The report needs to be sorted by IP address instead of description. In this situation you'll...

Thanks Wayne, I took a look and its pretty close. I currently have it working using VBA to cycle through a recordsource. I've had to do it that way because of how queries are handeled when you use the "Group by" setup.. I may be stuck with doing it this way.. :( Chris

The table gets populated with data when its created. All the IPs will be contiguous. There will be no missing IP addresses. If there are any not being used they will have "unassigned" in the description field. VBA is just fine. I've been working on building a new temporary table using VBA but...

Hello, I'm working on generating a report that will summarize our network IPs. I'm trying to make groups in the report but keep the IP addresses sequential. Also I want to show the first and last IP of a common group and not have a large report taken up by "unassigned" or "DHCP" IP addresses...