Searching Access

[SkankyDog]

Hi,

I am looking to transfer a number of spreadsheets that I use to track IP Addresses to an Access Database, I have set up the tables and fields, what I would like to do is search for unused IP Addressees from from the populated table/fields.

Thanks in advance

 

[pr2-eugin]

Hello SkankyDog, Welcome to AWF

Please do not post Question in the Introduction Area. I have moved your question to a more appropriate category. I am sure someone will be along shortly to help you. Good luck !

 

[Mile-O]

First things first: are you replicating these spreadsheets like for like in an Access table, or have you taken the necessary steps to design/normalise your data into a set of tables in Access?