I have the following code but it just won't work
DoCmd.RunSQL "INSERT INTO CBUDPresG ( Utility_Type, Month, Period, SumOfCost" & _
"SELECT [Central_Budget_Utilities_Data_(Present)].Utility_Type, [Central_Budget_Utilities_Data_(Present)].Period AS Month, Format(DateAdd("d",7,[Date_TaxPoint]),"yyyymm") AS Period, Sum([Central_Budget_Utilities_Data_(Present)].Cost) AS SumOfCost" & _
"FROM [Central_Budget_Utilities_Data_(Present)]" & _
"GROUP BY [Central_Budget_Utilities_Data_(Present)].Utility_Type, [Central_Budget_Utilities_Data_(Present)].Period, Format(DateAdd("d",7,[Date_TaxPoint]),"yyyymm")" & _
"ORDER BY [Central_Budget_Utilities_Data_(Present)].Utility_Type, Format(DateAdd("d",7,[Date_TaxPoint]),"yyyymm");"
Any help appreciated
Thanks
Geoff
DoCmd.RunSQL "INSERT INTO CBUDPresG ( Utility_Type, Month, Period, SumOfCost" & _
"SELECT [Central_Budget_Utilities_Data_(Present)].Utility_Type, [Central_Budget_Utilities_Data_(Present)].Period AS Month, Format(DateAdd("d",7,[Date_TaxPoint]),"yyyymm") AS Period, Sum([Central_Budget_Utilities_Data_(Present)].Cost) AS SumOfCost" & _
"FROM [Central_Budget_Utilities_Data_(Present)]" & _
"GROUP BY [Central_Budget_Utilities_Data_(Present)].Utility_Type, [Central_Budget_Utilities_Data_(Present)].Period, Format(DateAdd("d",7,[Date_TaxPoint]),"yyyymm")" & _
"ORDER BY [Central_Budget_Utilities_Data_(Present)].Utility_Type, Format(DateAdd("d",7,[Date_TaxPoint]),"yyyymm");"
Any help appreciated
Thanks
Geoff