In my Access 2013 Database, I have a Table entitled, "Inventory", where I collect among other things, the PC's IP Address, Physical MAC Address and Wireless MAC Address. I am trying to develop a Query where the "Inventory" Table is searched within those fields for whatever value the User puts into a particular Text Box of which would be an IP Address or a MAC Address. If found, it would list that entire data row. I know how to do it if looking for a value within a single field of a Table but not for multiple fields within a Table. The IP or MAC Address entered would be unique as the Table is set to not allow duplications within any of those fields so if what the User entered in the Text Box is in the "Inventory" Table, it would only be listed once in one of those three fields.
Any ideas? The closest I've come had something to do with an "Except" Statement but I don't think that fits my particular situation.