How to save crosstab query result into temp table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I am VBA case. Do you know how to do this. Please give me more detail of it.

Thanks
John

Roger Carlson said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top