Queries from a form

[ctr1085]

I'm stuck trying to figure out how to update a query I have already saved. Here's my situation, I have already created a query called "REPORT_STMT_Breakout" and I want to be able to change this query based upon some date variables on a form. I'm using this query to create a pivot table. I can create the basic query, but I cannot figure out how to modify the saved query to accommodate the variables. Any help would be appreciated.

Here's the current query SQL:

SELECT PARENT, TYPE, SUM(TOTAL) AS COMBINED
FROM [

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '1. IND_Amount' as TYPE,
  IND_Amount AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '2. SBG_Amount' as TYPE,
 SBG_Amount AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '3. IND_Bonus_Amount' as TYPE,
  IND_Bonus_Amount AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '4. SBG_Bonus_Amount' as TYPE,
  SBG_Bonus_Amount AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION 

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '5. Licensing Fees' as TYPE,
  Licensing_Fees AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION 

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '6. IND Misc Expenses' as TYPE,
  IND_Misc_Expenses AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION 

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '7. SBG Misc Expenses' as TYPE,
  SBG_Misc_Expenses AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION 

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '8. Other Receivables' as TYPE,
  Other_Receivables AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

UNION 

SELECT 
  tblStmt_Tracking.Parent_Carrier_Name AS PARENT, 
  '9. Unknown_Amount' as TYPE,
  Unknown_Amount AS TOTAL
FROM 
  tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID

]. AS BREAKOUT
GROUP BY PARENT, TYPE
ORDER BY PARENT, TYPE;

I plan on adding date variables to this query.

 

[ctr1085]

Anyone know how to update a saved query with new criteria?

I was researching "QueryDef", but I'm not 100% sure how to go about it.