Field Calculation

  • Thread starter Thread starter lastiko
  • Start date Start date
L

lastiko

Guest
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
 
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
 

Users who are viewing this thread

Back
Top Bottom