Skip to Content
0
Former Member
Dec 07, 2011 at 01:07 AM

Confused with Formula

23 Views

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?