Comparing 2 fields in NL Function

hansfousert

How to retrieve records from a table, where you want to use 2 fields as a filter? I.e. you want to compare both fields.

So: show me all records where Field 1 is equal to Field 2. Or show me all records where Field 1 is not equal to Field 2.


The syntax is:

EQUAL =NL("Rows","Table",,"Field1","=CONCATENATE(""="",NF(,""Field 2""))")

NOT EQUAL =NL("Rows","Table",,"Field1","=CONCATENATE(""<>"",NF(,""Field2""))")

hansfousert

Oops! This one was meant as a reply to a Jet Reports posting. :oops:

But you already recognised the functions, didn't you

Anyhow, even though I failed to use the link, it is a nice feature, isn't it?