Hi,
I have a table "Chart" which contains a field called "IP Address," and a table "FT Worth" which has a field called "Endpoint".
I need to show only the records that do NOT have a match on the ip address.
For Example: Chart / IP Address
10.5.3.4
10.1.9.2
FT Worth/ EndPoint
10.1.9.2
11.5.5.1
In this case, only the records that have the IP address 10.5.3.4 and 11.5.5.1 should display because they do not match.
So I selected the records with a formula of:
{chart.IP Address} <> {Ft Worth.Endpoint} however I got "0" zero records.
Can you shed some light on what I am doing wrong?