I have a query (BoM_ItemAnalysis_RunTot) with a calculation in it which does a running total on demand for material. I also have a calculation which subtracts the running total from the On Hand inventory to identify which builds I may run out of parts on.
I need to create a temp table to due further analysis and generate reports from.
The query runs in less than 1 second.
I created an append query, using (BoM_ItemAnalysis_RunTot) as the source to append the results to a temporary table. I first did a make table and only ran it against 1 record to create the table. I then removed the criteria to append all records and all it will do now is run.
My SQL is below for the append. Thoughts on how I can make this work?
INSERT INTO BoM_ItemAnalysis_RunTot_T ( ID, Component, BuildPriority, RECOV_DATE, PO_RTS, Comp_Descript, Comp_Type, Comp_Stat, TotalQty, RunningTotal, OH, Balance, [S&OP_CATEGORY], PART, CAT_Part, PO_RTS_DATE, STATUS, PRODUCT_DESCRIPTION, PRODUCT_NAME )
SELECT BoM_ItemAnalysis_RunTot.ID, BoM_ItemAnalysis_RunTot.Component, BoM_ItemAnalysis_RunTot.BuildPriority, BoM_ItemAnalysis_RunTot.RECOV_DATE, BoM_ItemAnalysis_RunTot.PO_RTS, BoM_ItemAnalysis_RunTot.Comp_Descript, BoM_ItemAnalysis_RunTot.Comp_Type, BoM_ItemAnalysis_RunTot.Comp_Stat, BoM_ItemAnalysis_RunTot.TotalQty, BoM_ItemAnalysis_RunTot.RunningTotal, BoM_ItemAnalysis_RunTot.OH, BoM_ItemAnalysis_RunTot.Balance, BoM_ItemAnalysis_RunTot.[S&OP_CATEGORY], BoM_ItemAnalysis_RunTot.PART, BoM_ItemAnalysis_RunTot.CAT_Part, BoM_ItemAnalysis_RunTot.PO_RTS_DATE, BoM_ItemAnalysis_RunTot.STATUS, BoM_ItemAnalysis_RunTot.PRODUCT_DESCRIPTION, BoM_ItemAnalysis_RunTot.PRODUCT_NAME
FROM BoM_ItemAnalysis_RunTot
WHERE (((BoM_ItemAnalysis_RunTot.RECOV_DATE)<Now()+90));