Script that looks at two files
I have two separate files and a script that goes to one file and searches for a date range and then sorts, then goes to the other file, does the same find, then sorts. It then goes to a layout in the second file which references one field from the first file. The problem is that the field reports the total from the entire file, not from the found set. Is there a way to make it just look at the found set?