How to save crosstab query result into temp table.

[John]

Hi,

I have working crosstab query

transform sum(PF) select [1] from [BNS-3Q04] group by [1] order by [1] pivot
[T] in ('1','2');

I would like to save into temp table (like select into). So I can join
another query

transform sum(PF) select [1] from [BNS-3Q04] group by [1] order by [1] pivot
[cell] in ('1' , '2','3','4','5','6');

with it.

Any idea?

Thanks
John

 

[Roger Carlson]

Save each query as separate named queries and create a third query joining
them.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[john]

I am VBA case. Do you know how to do this. Please give me more detail of it.

Thanks
John

Save each query as separate named queries and create a third query joining
them.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hi,

I have working crosstab query

transform sum(PF) select [1] from [BNS-3Q04] group by [1] order by [1] pivot
[T] in ('1','2');

I would like to save into temp table (like select into). So I can join
another query

transform sum(PF) select [1] from [BNS-3Q04] group by [1] order by [1] pivot
[cell] in ('1' , '2','3','4','5','6');

with it.

Any idea?

Thanks
John