Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoThe 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
------------------------------
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
------------------------------
JovanVucovich
3 years agoQrew Member
Thank you,
I had mis-type in my example, it was supposed to be XEX.
It worked to that [field 7] not matching when the rest do match.
I was thinking the XEX was an exclusion operation to exclude the display of that field for the listed matching fields, which why I needed it for the [Record ID#]. But thinking about it, that is what the 3 at the end of the formula is for to display that data in Field ID 3.
------------------------------
Jovan Vucovich
------------------------------
I had mis-type in my example, it was supposed to be XEX.
It worked to that [field 7] not matching when the rest do match.
I was thinking the XEX was an exclusion operation to exclude the display of that field for the listed matching fields, which why I needed it for the [Record ID#]. But thinking about it, that is what the 3 at the end of the formula is for to display that data in Field ID 3.
------------------------------
Jovan Vucovich
------------------------------