|
Hello, I've written a report that gives me estimated costs by category. I want to exclude estimates that are routed to a particular machine.
However, when I exclude the machine code in my selection formula, my report gains lines because instead of having one line per estimate, I now have one line for each remaining machine routed for that estimate.
What I'd like to do is exclude the entire estimate from the report if one of the machines routed for that estimate is on my list.
Cost table > mfg table linked by the estimate number
So there is a one to many comparison.
Help!
|