View Full Version : Field Calculation


lastiko
08-09-2001, 01:46 PM
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
08-13-2001, 08:19 AM
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