INSERT INTO awardhistory (ID, AgentID, DateAwarded, NumberOfAwardUnits) VALUES ('#CreateUUID()#', '#Client.AgentID#', #CreateODBCDate(Now())#, #Form.NumberOfAwardUnits#) UPDATE agents SET FreeUnitsAwarded = FreeUnitsAwarded + #Val(Form.NumberOfAwardUnits)#, FreeUnitsRemaining = FreeUnitsAwarded - FreeUnitsAllocated WHERE LoginID IN (SELECT ID FROM logins WHERE AccessLevel <> 'I') SELECT DateAwarded, NumberOfAwardUnits FROM awardhistory WHERE DateAwarded =(SELECT MAX(DateAwarded) FROM awardhistory) ICS-CONNECT ADMINISTRATION - Award Monthly Promotional Units
#Client.StatMsg#



Award Additional Promotional Participant Units
Date & ## of Last Award:
Units to Award:
Enter the number of units that you would like to award for promotional work, then click on the Submit button.