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.","<>@@")