Comparing Text Fields

[SDAccess]

I'm new to Access, I have experience with Oracle and MySQL databases. So here's the deal. I have two excel spreadsheets. I created and Access database and imported the spreadsheets and created two tables.

What I'm trying to do is compare IP addresses in the two tables. I made the IP address columns text fields. Then I do something like this:

WHERE
A.ip_address LIKE B.ip

and


WHERE
A.ip_address = B.ip




I come up with zero results. This may be true but I want to make sure I am choosing the correct data type for the IP address when creating the table. I also want to make sure I am comparing the strings correctly.

Any suggestions or advice would be appreciated.

[orange]

Post a jpg of your table designs, or post your database. Without some data, or at least your table structure, we are only guessing.