'Set Fleet_Average_ID gappInputFile.CurrentDb.Execute "UPDATE Base_Year_Population SET Base_Year_Population.Fleet_Average_ID = 2 WHERE (((Base_Year_Population.Fleet_Average_ID)<>1));" '<50 HP exempt gappInputFile.CurrentDb.Execute "UPDATE Base_Year_Population SET Base_Year_Population.Fleet_Average_ID = 3 WHERE (((Base_Year_Population.Average_HP)<50));" 'set one fleet to fleet average for code gappInputFile.CurrentDb.Execute "UPDATE Base_Year_Population SET Base_Year_Population.Fleet_Average_ID = 0 WHERE (((Base_Year_Population.Tier)='4f'));" '>750, T1 & T0 gappInputFile.CurrentDb.Execute "UPDATE Fleet_Size INNER JOIN Base_Year_Population ON (Fleet_Size.Fleet_ID = Base_Year_Population.Fleet_ID) AND (Fleet_Size.Calendar_Year = Base_Year_Population.Calendar_Year) SET Base_Year_Population.Tier_Restrict_ID = 2022 WHERE (((Base_Year_Population.Calendar_Year)=2016) AND ((Base_Year_Population.Average_HP)>750) AND ((Base_Year_Population.Tier)='1' Or (Base_Year_Population.Tier)='0'));" '>750, T2 gappInputFile.CurrentDb.Execute "UPDATE Fleet_Size INNER JOIN Base_Year_Population ON (Fleet_Size.Fleet_ID = Base_Year_Population.Fleet_ID) AND (Fleet_Size.Calendar_Year = Base_Year_Population.Calendar_Year) SET
'Set Fleet_Average_ID gappInputFile.CurrentDb.Execute "UPDATE Base_Year_Population SET Base_Year_Population.Fleet_Average_ID = 2 WHERE (((Base_Year_Population.Fleet_Average_ID)<>1));" '<50 HP exempt gappInputFile.CurrentDb.Execute "UPDATE Base_Year_Population SET Base_Year_Population.Fleet_Average_ID = 3 WHERE (((Base_Year_Population.Average_HP)<50));" 'set one fleet to fleet average for code gappInputFile.CurrentDb.Execute "UPDATE Base_Year_Population SET Base_Year_Population.Fleet_Average_ID = 0 WHERE (((Base_Year_Population.Tier)='4f'));" '>750, T1 & T0 gappInputFile.CurrentDb.Execute "UPDATE Fleet_Size INNER JOIN Base_Year_Population ON (Fleet_Size.Fleet_ID = Base_Year_Population.Fleet_ID) AND (Fleet_Size.Calendar_Year = Base_Year_Population.Calendar_Year) SET Base_Year_Population.Tier_Restrict_ID = 2022 WHERE (((Base_Year_Population.Calendar_Year)=2016) AND ((Base_Year_Population.Average_HP)>750) AND ((Base_Year_Population.Tier)='1' Or (Base_Year_Population.Tier)='0'));" '>750, T2 gappInputFile.CurrentDb.Execute "UPDATE Fleet_Size INNER JOIN Base_Year_Population ON (Fleet_Size.Fleet_ID = Base_Year_Population.Fleet_ID) AND (Fleet_Size.Calendar_Year = Base_Year_Population.Calendar_Year) SET
pe_model_install.docx