Hi All,
I have been struggling to write a query which will give me following results in field DistTotal as shown where:
RefNo field is variable
For placing 1 Default of DistTotal Value = 0
For placing 2 Default of DistTotal Value = Lenghth Value of placing 1
For placing 3 Default of DistTotal...