UPDATE agents SET FreeUnitsAwarded = FreeUnitsAwarded + #Val(ListGetAt(Form.UnitsToAdd, NumIdx))#, FreeUnitsRemaining = FreeUnitsAwarded - FreeUnitsAllocated WHERE ID = '#IDidx#' SELECT agents.*, logins.AccessLevel FROM agents LEFT OUTER JOIN logins ON (agents.LoginID = logins.ID) WHERE (logins.AccessLevel = "C" OR logins.AccessLevel = "O") ORDER BY agents.LastName, agents.FirstName ICS-CONNECT ADMINISTRATION - Add Assessment Promotional Units Manually
#Client.StatMsg#



bgcolor="##e4ffdf" >
ALL OUTSIDE AGENTS - QUALIFIED FOR PROMOTIONAL UNITS
Enter the number of Promotional units you want to add for each agent,
then click the 'Add Units' button.
Agent Name Company Name   Units In Bank Number of Units To Add
#GetAllAgents.LastName#, #GetAllAgents.FirstName# #GetAllAgents.CompanyName# #GetAllAgents.AccessLevel# #NumberFormat(GetAllAgents.FreeUnitsRemaining, '999,999')#