Creating A Table In Sql

Hi,
I ve got an access db thats attached to a java application.
I need to be able to create a temporary table that stores a result set, its necessary to do this as the java app needs to perform lots of repeated operations on this temp table.

I was think something like this would work:

DROP TABLE tempResults
CREATE TABLE tempResults
AS
SELECT col1, col2, col3 ....
FROM orginalTable


So i tried this:

Create table temptable AS
SELECT education,
FROM supermarketTable;


but it doesnt work, access complains about syntax error in create statment.

Could anyone give me some pointers?

thanks in advance!