Re: Exporting 2 queries into 1 excel spread***

UNION the queries together, then export.

Select * from tablename

UNION

Select * from tablename

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

"tanhus" <tanhus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C1BB3D4-2E76-4780-BAA5-2F008A79C4BF@xxxxxxxxxxxxxxxx
I have a form which processes/creates 2 queries, "Category Query" &"Project
Query" and opens them up. I want this same button to export both these
queries into one excel spread***. I want them both to be displayed in
one
work***, one above the other. They both contain the same amount of
columns,
so allignment will not play an issue in this. I also want an option of
where
to save the excel spread*** and what to save it as. Hopefully I am able
to
do this.
Thanks to those who can help.


.