I don't see any relationship explaining how your first set of values produces one of the values in the second set or did you mean the opposite? Either way I don't see any info explaining how one value produces the other.
Thanks for your reply !!!
I am explaining from starting. I have one table that is ABC with 4 fields. One is ID field(Number Type), second is Total Field(Calculation Field), third is calc1(Calculation Field) and fourth is calc2(Calculation Field). Values of ID field, Total field, Calc1 are :
ID Total Calc1 Calc2(?)
1 450 1-450 1-5
2 450 2-450 1-5
3 450 3-450 1-5
4 450 4-450 1-5
5 450 5-450 1-5
6 500 6-500 6
7 600 7-600 7-8
8 600 8-600 7-8
I need fourth field(Calc2) values using calculation field. How can i do that? (It will match Calc1 in relationship, i think but it is not working because this is the unstored calculation field.)
My questions remain unanswered. I can't tell from your data how the values in the left field are supposed to produce the value in the Calc2 field. Now you've indicated that "They are related" but don't describe HOW they are related....
Are the Cal2 values representing the range of ID's where the totals remain the same?
I think that's it, but would prefer confirmation.
If that's correct, a self join could match records in the same table with the same total, but that in turn may be the problem as this won't work if "Total" is an unstored calculation.