logitestus (5/8/2014)
First off, I want to say how much I do appreciate those of you who are helping me.Secondly, I do apologize if I performed an epic-fail on trying to explain what I am trying to do. Dang it, why can't you just read my mind? 😀
To boil the requirement down, it should be something along these lines:
I want the starting totals per product and the ending totals per product, regardless of compartment. But I cannot trust the automated starting and ending totals (this is due to an internal departmental conflict) so I have to grab the associated "adjust" records, which are actually non-automated physical measurements.
Does this help?
But I cannot trust the automated starting and ending totals
ok...so are you saying that all doc_type with 'S' or 'E' are to be ignored?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day