An IIF that is killing me
Posted: Mon Dec 13, 2004 7:29 pm
I^ll be as brief as possible.____We have a recruitment program that issues awards based on certain thresholds achieved/crossed.____5 Recruits = Heartbar Award__10 Recruits = Heartbar Award__15 Recruits = Heartbar Award__ |__ |__ V____It^s simple to deal with the people on the main thresholds of 5(I use "IIF(MOD(Total_Recruits,5)=0,"HEARTBAR",""). We are going to run the output once a month, so I have to make sure the accumulations per period are correct. I^m using 3 Fields to try to acheive the solution:____Total_Recruits: A complete historical count of all their recruits__Current_Recruits: Recruits for current period (ie. 11/1/04-11/30/04)__Previous_Recruits: Recruits for prev period (ie. <11/1/04).____How do I come up with this. I hope my questions makes sense.____Thanks in advance.