Sandeep-

If by "project" you mean an adp application, SQL Server works the same way
as Access.  You must build a View first that is your UNION query and then
build a Function or Stored Procedure for your SELECT INTO that uses the
union View in the FROM clause.

John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
   

-----Original Message-----
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of sandeep ta
Sent: Friday, August 12, 2005 12:23 AM
To: ms_access@yahoogroups.com
Subject: [ms_access] how to create temporary table.........

  
Hello,


     I am in middle of the project and i stuck in a problem where i wan t to
use many queries and the output of that should made table.

for ex.

query1
union
query2
union
query3
union
..
..
..

i want to create table to The output of the above. Can anybody help me in
solving this.

Sandeep T.A


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hdhulvf/M=362329.6886308.7839368.1510227
/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123831344/A=2894321/R=0/SIG=11dvsfulr
/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk
back!</a>.</font>
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links



 



------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a 
href="http://us.ard.yahoo.com/SIG=12hi27rke/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123857889/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life 
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ms_access/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to