INSERT INTO financialstotal 
            (category, 
             [cost center], 
             [code], 
             subcategory, 
             period ) 
SELECT all_actuals.category, 
       all_actuals.[cost center], 
       all_actuals.code, 
       all_actuals.subcategory, 
       all_actuals.period
FROM   all_actuals 
       LEFT JOIN [locations] 
              ON all_actuals.code = 
                 [locations].[code] 
WHERE  (( ( [locations].costcenter ) LIKE ( 
                  '*' & [all_actuals].[cost center] & '*' ) ));