I have a query with an output.
I want to insert the result of the query into a table.
here is my code
//Here I run the query
DoCmd.OpenQuery "Report2_MOS_CB_Count", acViewNormal, acEdit
//Here I want the result from the above query to be inserted into this table.
CurrentDb.Execute ("INSERT INTO Report_2_MTD_MOS_Containment( Dialed_Number, Call_Count, CreatedDate )" _
& "SELECT DATA_1, Counts, CreatedDate" _
& " FROM Report_2_MOS_CB_Count ")