0

Empty Filter on a Linked Table

Hi I have a query involving a linked table and I am receiving an empty filter on the link field No.  I have tried everything I know to avoid it but am having no luck.  I added in No. <> @@ and Source No. <> @@ as a hail Mary.  I checked my data and there is no Customer No. that is blank... any ideas?

Here is my statement:

=NL("Rows","Item Ledger Entry","Source No.","Source Type","Customer","Source No.","<>@@","Posting Date",$C$17,"Link=","Customer","No.","=Source No.","Sales Rep Code",$C$2,"No.","<>@@")

 

1 comment

Please sign in to leave a comment.