EDITED::: Sorry looked at the wrong qry.
The 7.64 won't show up in the Commission Report until about 2012. The S2009 plan is 5% for 36 months. After 36 months it switches to 1%. Sorry I'm not an Excel guru quite yet and my counta function didn't quite catch that. All the commissions with a start date later than Now() aren't applied.