Hi,
I have the attached Document, not sure the best way to do this but each month I take a snapshot of a table telling me the position of aged orders and the amount it is.
I then insert into the same table each day the latest Aged Orders and what the amount is.
What I want is for the Range field to always be selected from the table where the Type = "Start" which is when the data was first loaded in for that month.
If that ID has moved to another Range I still want it to show Amount it is for the "Start" Range.
Hopefully I have made myself clear?
Thanks