Andrew:
I wish we could this, but it does not work in this case.
We are searching for any Invoice that has the text: “cylinder”.
Only after it finds all these Invoices, I want to perform a second search, only in this group of Invoices, for the second text: “new rod”.
This would be where the text: "new rod" appears on a different Detail row.
By using the AND function, GV searches for Description lines that has both words on the same row – which is never.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON