Putting Headers with append queries?

  • Thread starter Thread starter scott
  • Start date Start date
S

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
 
*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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
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
 
With VBA Code, you would have to create a custom procedure that opens Excel
and populates the worksheet. BUT, if the instructor hasn't covered VBA
coding in the class yet, then I would suppose he/she would expect it to be
completed differently.
 
Back
Top