hello I need to divide the values of two filds.They are the same fields but have a different record id's is there a way to do it.
EXAMPLE: Record 1: Field A Record 2 :Field A divide field A of record 2 and record 1
Forum Discussion
Can you explain conceptually how the system would know which two records to use to do this division? I�m sure you have lots of records on your table.
In general it is very difficult to do more mathematical operations involving different records. But in any event your explanation is far from sufficient to give you an answer. What if there is 1000 records on your table. How was it supposed to know which two records you want to divide.