Forum Discussion

JovanVucovich's avatar
JovanVucovich
Qrew Member
4 years ago

Formula Query to search for matching records with the exception of a specific field not matching

I currently am using a Formula Query to identify when specific fields match it returns the Record ID# that has the matching data. This is to help identify duplicate record entries for things that can ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
The operator for Not Equals is XEX.  sort of the opposite of EX.

So try this

GetFieldValues(GetRecords("{5.EX. ' "&[Field 5] &" '} AND {6.EX. ' "&[Field 6] &" '} AND {7.XEX. ' "&[Field 7] &" '} AND {3.XEX. ' "&[Record ID#] &" '}" ),3)


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------