Forum Discussion
Solved
Comparing Values with Previous not based on Dates
Hi, Relative noobie here. I have checked many existing posts and videos but I am not getting how to approach the problem. I have 2 tables as below, with one-to-many from LOADS.load to HOLDIN...
Simple enough if the rule of "previous load" persists; even the LOADS table is redundant. (rule of "previous load": the max Load less than current Load)
Simple enough if the rule of "previous load" persists; even the LOADS table is redundant. (rule of "previous load": the max Load less than current Load)
Even though all solutions posted work, I like this one because I don't have to create the Load table and entries - even though I didn't ask for this.
Thanks all for helping me out.