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]