I have a Navigator database. In jet version 9, the following formula returned the vendor number and bank account number from the G/L Entry table. NL(,"G/L Entry","Source No.","Document No.",$V15,"G/L Register No.",$U15)
In Version 10, no vendor or bank information is being returned. This is because the Source Number is not on each line. I tried using NL First, but this does not work either. I want to return the First non blank record that is seen. Is this possible?
Date
Votes
1 comment
-
Jet Reports Historic Posts Do you just want to filter out the blanks for the Source No. field? You could do that by changing for your formula to:
NL(,"G/L Entry","Source No.","Document No.",$V15,"G/L Register No.",$U15,"Source No.","<>''")
Notice that in Jet filtering, you use to single quote characters to represent a blank value.
Regards,
Hughes
Please sign in to leave a comment.