I made a database many years ago for my business. I built it just after taking a class on Access, so it was all fairly simple for me. Now, over 9 years later, I have to make a simple change to an If statement and I can't seem to get it right. I use it to calculate my commission percentage based on my current pay plan, which was recently changed. Here is my trusty old statement:Attempting to keep all the old information, and add one more criteria, I tried nesting a second If statement in, to look like this:Code:Commission: IIf([Sale Date]<=37726,([Finance Log]!Reserve+[Finance Log]!CL+[Finance Log]!AH+[Finance Log]!GAP+[Finance Log]!VSA+[Finance Log]!TDR+[Finance Log]!Perma)*0.2,([Finance Log]!Reserve*0.14)+(([Finance Log]!CL+[Finance Log]!AH+[Finance Log]!GAP+[Finance Log]!VSA+[Finance Log]!TDR)*0.17)+([Finance Log]!Perma*0.2)+([Finance Log]!TAC*0.17)+([Finance Log]!Tire*0.17))The problem is, the results that are returned, even for deals after June 1, are still showing the old calculation. How can I fix this?Code:Commission: IIf([Sale Date]<=37726,([Finance Log]!Reserve+[Finance Log]!CL+[Finance Log]!AH+[Finance Log]!GAP+[Finance Log]!VSA+[Finance Log]!TDR+[Finance Log]!Perma)*0.2,IIf([Sale Date]>=40695,(([Finance Log]!Reserve+[Finance Log]!GAP)*0.14)+(([Finance Log]!CL+[Finance Log]!AH+[Finance Log]!TDR)*0.17)+(([Finance Log]!Perma+[Finance Log]!VSA)*0.2)+([Finance Log]!TAC*0.17)+([Finance Log]!Tire*0.17)+([Finance Log]!Setup*0.10),([Finance Log]!Reserve*0.14)+(([Finance Log]!CL+[Finance Log]!AH+[Finance Log]!GAP+[Finance Log]!VSA+[Finance Log]!TDR)*0.17)+([Finance Log]!Perma*0.2)+([Finance Log]!TAC*0.17)+([Finance Log]!Tire*0.17)+([Finance Log]!Setup*0.10))