Putting Headers with append queries?

[scott]

I have 3 queries I want to append to each other.

I want each to have its own headers though in the final
output..I output everything in excel 97

example
query 1

scott 12345

query 2

john 32654

query 3

412 222 3654 boss

When I put these together I want an excel file that looks
like this.

Emplyee Name Employee #
scott 12345

Boss Name Boss #
john 32654

Phone # Status
412 222 3654 boss

Thank you for any help
Scott

 

[[MVP] S. Clark]

*sniff* Do I smell homework?

Does this have to be completed using queries, or can it be done with VBA?

I would do it with VBA. Open an Excel worksheet and crank out the values
from each query to the worksheet.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[scott]

HA HA it can be done either way..How would I get them to
all extract to a worksheet and look like the way I needed
it?

I am a little confused on how to get this accomplished :-(

Scott