'Calculate total gappOutFile.DoCmd.RunSQL "UPDATE Total_Cost SET Total_Cost.Total_Cost = [Total_Cost]![SumOfCost_Bought]-[Total_Cost]![SumOfCost_Sold];" ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' End Sub Sub DistrictSummary() 'Sum Statewide gappOutFile.DoCmd.RunSQL "SELECT Population_Table.Calendar_Year, Population_Table.Equipment_Class, Sum(Population_Table.Population_Operating) AS SumOfPopulation_Operating, Sum(Population_Table.HC_EXH) AS SumOfHC_EXH, Sum(Population_Table.ROG_EXH) AS SumOfROG_EXH, Sum(Population_Table.TOG_EXH) AS SumOfTOG_EXH, Sum(Population_Table.CO_EXH) AS SumOfCO_EXH, Sum(Population_Table.NOx_EXH) AS SumOfNOx_EXH, Sum(Population_Table.PM_EXH) AS SumOfPM_EXH, Sum(Population_Table.PM2_5_EXH) AS SumOfPM2_5_EXH, Sum(Population_Table.PM10_EXH) AS SumOfPM10_EXH,
'Calculate total gappOutFile.DoCmd.RunSQL "UPDATE Total_Cost SET Total_Cost.Total_Cost = [Total_Cost]![SumOfCost_Bought]-[Total_Cost]![SumOfCost_Sold];" ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' End Sub Sub DistrictSummary() 'Sum Statewide gappOutFile.DoCmd.RunSQL "SELECT Population_Table.Calendar_Year, Population_Table.Equipment_Class, Sum(Population_Table.Population_Operating) AS SumOfPopulation_Operating, Sum(Population_Table.HC_EXH) AS SumOfHC_EXH, Sum(Population_Table.ROG_EXH) AS SumOfROG_EXH, Sum(Population_Table.TOG_EXH) AS SumOfTOG_EXH, Sum(Population_Table.CO_EXH) AS SumOfCO_EXH, Sum(Population_Table.NOx_EXH) AS SumOfNOx_EXH, Sum(Population_Table.PM_EXH) AS SumOfPM_EXH, Sum(Population_Table.PM2_5_EXH) AS SumOfPM2_5_EXH, Sum(Population_Table.PM10_EXH) AS SumOfPM10_EXH,
pe_model_install.docx