IF statement to deal with duplicates within fields
Is it possible to do calculations based on duplicates within the same field.
What I need to do is, if the IDs are the same (i.e. 1100007 = 1100007) and the Desc's are the same (i.e. Alloc = Alloc), then work out the absolute difference of the "Time" field (which is 3 minutes in this example).
I'm not sure what syntax to use which will enable me to do this.