make a temp table from crosstab query

[stigmatized]

guys,

hello everyone.

is it possible to make a temporary table from a crosstab query?

when im doing the syntax to make table query from a crosstab query, there is an error and it states as "syntax error in FROM clause."

here is my query:

SELECT TBL.* INTO TEMP1
FROM (TRANSFORM Sum(Amount) AS SumOfAmount
SELECT Cost_Center, [GL Account], Sum(Amount) AS [Total Of Amount]
FROM Budget
GROUP BY Cost_Center, [GL Account]


PIVOT Period) AS TBL;

please help me on this.