Hi All,
I am trying to write a function that would enable me to do something like this…..
NL("Rows","My Table",,"Link=","Field 1","MyFilter1",
OR,
"Field 2","MyFilter21")
the big problem is how do I achieve the bit in the middle which is the "OR" bit? Can I even do this ?
I have searched the forums and looked at the help file, but I cannot find anything that helps me figure out how to do.
Many thanks in advance.
Dean.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
So let me make sure I understand this. You want to filter the result for either Field 1 = MyFilter1 OR Field 2 = MyFilter2 is that right? I'm not sure where the Link= is coming in with your formula. Are you actually linking to another table and filtering by both fields on another table? Is one of the filter fields on the main table and the other one on a different table?
Regards,
Hughes
Please sign in to leave a comment.