What is the best way to call a value in a field. I want to call the values in a field, one at a time, perform some logic operations on them, and input into another field in the same record. Then continue on to the next record.
What I am trying to do is to count duplicate invoices which requires sorting, logically determining if the invoice is a duplicate, if not then I number one, if it is I number two and continue counting until it is no longer a duplicate and start at one again. I need to input the results into another field.
Any guidance would be most appreciated.
What I am trying to do is to count duplicate invoices which requires sorting, logically determining if the invoice is a duplicate, if not then I number one, if it is I number two and continue counting until it is no longer a duplicate and start at one again. I need to input the results into another field.
Any guidance would be most appreciated.
