I work in IT at a small medical company and I manage the database for all of our devices, specifically things like computers, multifunction printers, switches, access points, etc. All of these things have IP addresses and I would like to create a query that shows all devices that have an IP address assigned that I can use like an IP directory. I'm relatively new to Access so I'm stumped on how I could do this. Any ideas?