Report with All IPs of my servers

[NorthH]

I cannot seem to put together a report of all the IP addresses for each of my servers.
Could you help me with that. I reference the tblNetwork but it is not working correctly

[NorthH]

Great!!! Thanks as always!

[Hemoco · Accepted solution]

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblNetwork.Description, tblNetwork.IPAddress
From tblComputers Inner Join
  tblNetwork On tblComputers.Computername = tblNetwork.Computername Inner Join
  web40repallservers On web40repallservers.Computername =
    tblComputers.Computername
Where tblNetwork.IPAddress <> '' And tblNetwork.IPAddress <> '0.0.0.0'
Order By tblComputers.Computer, tblNetwork.Description

[NorthH]

Yes Perfect except how just for servers?

[Hemoco]

Something like this:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblNetwork.Description, tblNetwork.IPAddress
From tblComputers Inner Join
  tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where tblNetwork.IPAddress <> '' And tblNetwork.IPAddress <> '0.0.0.0'
Order By tblComputers.Computer, tblNetwork.Description