I suggest you DO NOT use spaces in object names. A better form name would be "MaintenanceAgreements" (no space)
---------
You have
Code:
= iif(eval(Forms![Maintenance Agreements]![Months] =<12 and Forms![Maintenance Agreements]![Amount] / Forms![Maintenance Agreements]![Months] =>10000,
Forms![Maintenance Agreements]![Account] / Forms![Maintenance Agreements]![Months] ,""))
Shouldn't [Account] be [Amount]??
---------
You have listed 3 conditions:
1) the number of months is equal to, or less than, 12 AND the amount, divided by the months, is greater than, or equal to 10,000
then put the amount in the start month and populate the months to end month
2) If the number of months is greater than 12 and the amount, divided by the months, is greater than, or equal to 5,000
then put the amount in the start month and populate the months to end month
3) If neither of these scenarios is true, populate the start month with the total amount
For 1 & 2, is "the amount" the value of Forms![Maintenance Agreements]![Amount]??
Or is it the value of Forms![Maintenance Agreements]![Amount] / Forms![Maintenance Agreements]![Months]??
For 3, I'm guessing you want the value from Forms![Maintenance Agreements]![Amount]? (total amount?)
---------
This is the formula I came up with: (* untested **)
Code:
= IIF(Forms![Maintenance Agreements]![Months] =<12 and Forms![Maintenance Agreements]![Amount] / Forms![Maintenance Agreements]![Months] =>10000,
Forms![Maintenance Agreements]![Amount] / Forms![Maintenance Agreements]![Months],
IIF(Forms![Maintenance Agreements]![Months] >12 and Forms![Maintenance Agreements]![Amount] / Forms![Maintenance Agreements]![Months] =>5000,
Forms![Maintenance Agreements]![Amount] / Forms![Maintenance Agreements]![Months] , Forms![Maintenance Agreements]![Amount]))
---------
You also stated: "I want the calculated field to look at the month (January 2022) and if the term start date is in January 2022".
At this point, I'm not sure where the the term start date fits in this calculation.
What do you want to do if the the term start date is February 2022?
---------
I WOULD NOT use calculated FIELDS in a table. I would do the calculations in a query.
BTW, welcome to the forum....