select into statement

Can I use :
select field into temptable from table1 where...
then :
select field into temp2 from temptable where.....
then:
use temp2 to make a chart???
this is the code I use in my access/VBA project doesn't work with vb...
the second select has a calculation in it that is why I need two select statments.
I have a connection open to my sql db, is this where my temptable is stored , so I can access the data for my report

[Edited by jordan0904 on 11-06-2000 at 09:57 AM]

Yes you can, but why not just use Table 1 directly?

You may need to refresh the collections after running the SQL statements or the data may not be 'visible'.

Cheers,

Paul