Modify Query SQL Dynamically

Small portion / sample of the SQL statement being modified.  It uses many many sums, and a few expressions.  I would need to add Sum and Group By fields to this query.

SELECT tbl_ProductionDates.Number, tbl_ProductionDates.Week, tbl_ProductionDates.Month, tbl_Specialist.Team_Number, tbl_Specialist.E_Number, tbl_Specialist.Supervisor, tbl_Specialist.Specialist, tbl_Specialist.Date_In_Position, tbl_Specialist.Desk_Code, tbl_Specialist.Position, Sum(tbl_Completes.time_PTO_hrs) AS time_PTO_hrs, Sum(tbl_Completes.time_mtg_hrs) AS time_mtg_hrs, Sum(tbl_Completes.time_class_hrs) AS time_class_hrs, Sum(tbl_Completes.time_holiday_hrs) AS time_holiday_hrs, Sum(tbl_Completes.time_special_project_hrs) AS time_special_project_hrs, Sum(tbl_Completes.time_system_downtime_hrs) AS time_system_downtime_hrs, Sum(tbl_Completes.time_hrs_worked) AS time_hrs_worked, IIf([time_hrs_worked]>40,IIf(([time_hrs_worked]-40)>0,([time_hrs_worked]-40),0),0) AS Overtime, Sum(tbl_Completes.prod_sng) AS prod_sng, Sum(tbl_Completes.dp_sng) AS dp_sng, Sum(tbl_Completes.time_sng) AS time_sng, Sum(tbl_Completes.prod_paper) AS prod_paper, Sum(tbl_Completes.dp_paper) AS dp_paper, Sum(tbl_Completes.time_paper) AS time_paper, Sum(tbl_Completes.prod_pended) AS prod_pended, Sum(tbl_Completes.dp_pended) AS dp_pended, Sum(tbl_Completes.time_pended) AS time_pended

I have that, I only posted a piece of the SQL, the full SQL is at the bottom of this post.  I unfortunately have to have the tbl_ProductionDates table to break down Fiscal months, production weeks (different from normally numbered weeks), and holidays for automation and reporting.  For this reason, Week and Month are linked for sorting/grouping in reports.

SELECT tbl_ProductionDates.Number, tbl_ProductionDates.Week, tbl_ProductionDates.Month, tbl_Specialist.Team_Number, tbl_Specialist.EmpID, tbl_Specialist.Supervisor, tbl_Specialist.Specialist, tbl_Specialist.Date_In_Position, tbl_Specialist.Desk_Code, tbl_Specialist.Position, Sum(tbl_Completes.time_PTO_hrs) AS time_PTO_hrs, Sum(tbl_Completes.time_mtg_hrs) AS time_mtg_hrs, Sum(tbl_Completes.time_class_hrs) AS time_class_hrs, Sum(tbl_Completes.time_holiday_hrs) AS time_holiday_hrs, Sum(tbl_Completes.time_special_project_hrs) AS time_special_project_hrs, Sum(tbl_Completes.time_system_downtime_hrs) AS time_system_downtime_hrs, Sum(tbl_Completes.time_hrs_worked) AS time_hrs_worked, IIf([time_hrs_worked]>40,IIf(([time_hrs_worked]-40)>0,([time_hrs_worked]-40),0),0) AS Overtime, Sum(tbl_Completes.prod_Auto) AS prod_Auto, Sum(tbl_Completes.dp_Auto) AS dp_Auto, Sum(tbl_Completes.time_Auto) AS time_Auto, Sum(tbl_Completes.prod_paper) AS prod_paper, Sum(tbl_Completes.dp_paper) AS dp_paper, Sum(tbl_Completes.time_paper) AS time_paper, Sum(tbl_Completes.prod_pended) AS prod_pended, Sum(tbl_Completes.dp_pended) AS dp_pended, Sum(tbl_Completes.time_pended) AS time_pended, Sum(tbl_Completes.prod_correspondence) AS prod_correspondence, Sum(tbl_Completes.dp_correspondence) AS dp_correspondence, Sum(tbl_Completes.time_correspondence) AS time_correspondence, Sum(tbl_Completes.prod_underwriting) AS prod_underwriting, Sum(tbl_Completes.dp_underwriting) AS dp_underwriting, Sum(tbl_Completes.time_underwriting) AS time_underwriting, Sum(tbl_Completes.prod_SIC) AS prod_SIC, Sum(tbl_Completes.dp_SIC) AS dp_SIC, Sum(tbl_Completes.time_SIC) AS time_SIC, Sum(tbl_Completes.prod_welcome_call) AS prod_welcome_call, Sum(tbl_Completes.dp_welcome_call) AS dp_welcome_call, Sum(tbl_Completes.time_welcome_call) AS time_welcome_call, Sum(tbl_Completes.prod_new_accounts) AS prod_new_accounts, Sum(tbl_Completes.dp_new_accounts) AS dp_new_accounts, Sum(tbl_Completes.time_new_accounts) AS time_new_accounts, Sum(tbl_Completes.prod_reissue) AS prod_reissue, Sum(tbl_Completes.dp_reissue) AS dp_reissue, Sum(tbl_Completes.time_reissue) AS time_reissue, Sum(tbl_Completes.prod_life) AS prod_life, Sum(tbl_Completes.dp_life) AS dp_life, Sum(tbl_Completes.time_life) AS time_life, Sum(tbl_Completes.prod_paper_conversion) AS prod_paper_conversion, Sum(tbl_Completes.dp_paper_conversion) AS dp_paper_conversion, Sum(tbl_Completes.time_paper_conversion) AS time_paper_conversion, Sum(tbl_Completes.prod_Auto_conversion) AS prod_Auto_conversion, Sum(tbl_Completes.dp_Auto_conversion) AS dp_Auto_conversion, Sum(tbl_Completes.time_Auto_conversion) AS time_Auto_conversion, Sum(tbl_Completes.prod_management_file) AS prod_management_file, Sum(tbl_Completes.dp_management_file) AS dp_management_file, Sum(tbl_Completes.time_management_file) AS time_management_file, Sum(tbl_Completes.prod_nonumber) AS prod_nonumber, Sum(tbl_Completes.dp_nonumber) AS dp_nonumber, Sum(tbl_Completes.time_nonumber) AS time_nonumber, Sum(tbl_Completes.prod_paper_paid) AS prod_paper_paid, Sum(tbl_Completes.dp_paper_paid) AS dp_paper_paid, Sum(tbl_Completes.time_paper_paid) AS time_paper_paid, Sum(tbl_Completes.prod_pended_paid) AS prod_pended_paid, Sum(tbl_Completes.dp_pended_paid) AS dp_pended_paid, Sum(tbl_Completes.time_pended_paid) AS time_pended_paid, Sum(tbl_Completes.prod_paper_cod) AS prod_paper_cod, Sum(tbl_Completes.dp_paper_cod) AS dp_paper_cod, Sum(tbl_Completes.time_paper_cod) AS time_paper_cod, Sum(tbl_Completes.prod_escalation_file) AS prod_escalation_file, Sum(tbl_Completes.dp_escalation_file) AS dp_escalation_file, Sum(tbl_Completes.time_escalation_file) AS time_escalation_file, Sum(tbl_Completes.prod_DOI_file) AS prod_DOI_file, Sum(tbl_Completes.dp_DOI_file) AS dp_DOI_file, Sum(tbl_Completes.time_DOI_file) AS time_DOI_file, Sum(tbl_Completes.prod_rush_file) AS prod_rush_file, Sum(tbl_Completes.dp_rush_file) AS dp_rush_file, Sum(tbl_Completes.time_rush_file) AS time_rush_file, Sum(tbl_Completes.prod_specialty_Auto) AS prod_specialty_Auto, Sum(tbl_Completes.dp_specialty_Auto) AS dp_specialty_Auto, Sum(tbl_Completes.time_specialty_Auto) AS time_specialty_Auto, Sum(tbl_Completes.prod_specialty_paper) AS prod_specialty_paper, Sum(tbl_Completes.dp_specialty_paper) AS dp_specialty_paper, Sum(tbl_Completes.time_specialty_paper) AS time_specialty_paper, Sum(tbl_Completes.prod_specialty_Auto_conversions) AS prod_specialty_Auto_conversions, Sum(tbl_Completes.dp_specialty_Auto_conversions) AS dp_specialty_Auto_conversions, Sum(tbl_Completes.time_specialty_Auto_conversions) AS time_specialty_Auto_conversions, Sum(tbl_Completes.prod_rework) AS prod_rework, Sum(tbl_Completes.dp_rework) AS dp_rework, Sum(tbl_Completes.time_rework) AS time_rework, tbl_Specialist.[Auto Quota], tbl_Specialist.[Paper Quota], tbl_Specialist.[Pended Quota], tbl_Specialist.[Correspondence Quota], tbl_Specialist.[Underwriting Quota], tbl_Specialist.[SIC Quota], tbl_Specialist.[Welcome Call Quota], tbl_Specialist.[New Accounts Quota], tbl_Specialist.[Reissue Quota], tbl_Specialist.[Life Quota], tbl_Specialist.[Paper Conversion Quota], tbl_Specialist.[Auto Conversion Quota], tbl_Specialist.[Management File Quota], tbl_Specialist.[NoNumber Quota], tbl_Specialist.[Paper Paid Quota], tbl_Specialist.[Pended Paid Quota], tbl_Specialist.[Paper COD Quota], tbl_Specialist.[Escalation File Quota], tbl_Specialist.[DOI File Quota], tbl_Specialist.[Rush File Quota], tbl_Specialist.[Specialty Auto Quota], tbl_Specialist.[Specialty Paper Quota], tbl_Specialist.[Specialty Auto Conversion Quota], tbl_Specialist.[Rework Quota], (([Correspondence Quota]*[time_correspondence])+([DOI File Quota]*[time_DOI_file])+([Escalation File Quota]*[time_escalation_file])+([Life Quota]*[time_life])+([Management File Quota]*[time_management_file])+([New Accounts Quota]*[time_new_accounts])+([NoNumber Quota]*[time_nonumber])+([Paper COD Quota]*[time_paper_cod])+([Paper Conversion Quota]*[time_paper_conversion])+([Paper Paid Quota]*[time_paper_paid])+([Paper Quota]*[time_paper])+([Pended Paid Quota]*[time_pended_paid])+([Pended Quota]*[time_pended])+([Reissue Quota]*[time_reissue])+([Rework Quota]*[time_rework])+([Rush File Quota]*[time_rush_file])+([SIC Quota]*[time_SIC])+([Auto Conversion Quota]*[time_Auto_conversion])+([Auto Quota]*[time_Auto])+([Specialty Paper Quota]*[time_specialty_paper])+([Specialty Auto Conversion Quota]*[time_specialty_Auto_conversions])+([Specialty Auto Quota]*[time_specialty_Auto])+([Underwriting Quota]*[time_underwriting])+([Welcome Call Quota]*[time_welcome_call])) AS ExpectedProd, tbl_Specialist.[Marketing Request], tbl_Specialist.[Marketing Request Quota], tbl_Completes.prod_marketing_request, tbl_Completes.dp_marketing_request, tbl_Completes.time_marketing_request
FROM (tbl_Completes INNER JOIN tbl_ProductionDates ON tbl_Completes.prod_date = tbl_ProductionDates.Day) INNER JOIN tbl_Specialist ON tbl_Completes.prod_EmpID = tbl_Specialist.EmpID
GROUP BY tbl_ProductionDates.Number, tbl_ProductionDates.Week, tbl_ProductionDates.Month, tbl_Specialist.Team_Number, tbl_Specialist.EmpID, tbl_Specialist.Supervisor, tbl_Specialist.Specialist, tbl_Specialist.Date_In_Position, tbl_Specialist.Desk_Code, tbl_Specialist.Position, tbl_Specialist.[Auto Quota], tbl_Specialist.[Paper Quota], tbl_Specialist.[Pended Quota], tbl_Specialist.[Correspondence Quota], tbl_Specialist.[Underwriting Quota], tbl_Specialist.[SIC Quota], tbl_Specialist.[Welcome Call Quota], tbl_Specialist.[New Accounts Quota], tbl_Specialist.[Reissue Quota], tbl_Specialist.[Life Quota], tbl_Specialist.[Paper Conversion Quota], tbl_Specialist.[Auto Conversion Quota], tbl_Specialist.[Management File Quota], tbl_Specialist.[NoNumber Quota], tbl_Specialist.[Paper Paid Quota], tbl_Specialist.[Pended Paid Quota], tbl_Specialist.[Paper COD Quota], tbl_Specialist.[Escalation File Quota], tbl_Specialist.[DOI File Quota], tbl_Specialist.[Rush File Quota], tbl_Specialist.[Specialty Auto Quota], tbl_Specialist.[Specialty Paper Quota], tbl_Specialist.[Specialty Auto Conversion Quota], tbl_Specialist.[Rework Quota], tbl_Specialist.[Marketing Request], tbl_Specialist.[Marketing Request Quota], tbl_Completes.prod_marketing_request, tbl_Completes.dp_marketing_request, tbl_Completes.time_marketing_request
HAVING (((tbl_Specialist.EmpID)="9332"))
ORDER BY tbl_ProductionDates.Number, tbl_ProductionDates.Week;

So the best way would be to delete the query and rebuild it through querydefs?  I can't break it down as it's needed for a fairly complex report.

Is this solution viable for a multi-user environment?  This query runs certain reports that can be pulled at any time by anyone that has access to the database.  There would be moments in time where a user could be running this report while another user is adding/removing a function from the database (deleting/creating a new query), and the report would give an error.