I have a fairly simple report that lists the computers by subnet. The only problem I am running into is that machines pick up new addresses over time and both are listed. Is there a way to list the most recent IP address and prevent duplicate computer names?
This is what I currently use:
Select tblNetwork.Computername, tblNetwork.IPAddress, tblNetwork.DHCPenabled From tblNetwork Where tblNetwork.IPAddress Like '%10.2%' And tblNetwork.DHCPenabled Like 'True'
