Field Calculation (1 Viewer)

[lastiko]

I have multiple fields that I am adding up together, and when it exceeds 730 days I want it to recalculate back 730 days. Also.. I do not want to have to go back and input information into these fields.

Email: morrisb@naswi.navy.mil

 

[AlanS]

Use the MOD . For example, the following statement will assign the sum of Field1, Field2 and Field3 to Total1, unless that sum is greater or equal to 730, in which case it will assign the remainder after an integer division of the sum by 730:

Total1 = (Field1 + Field2 + Field3) MOD 730