Export query to Excel with formated heading

When export from query to Excel, I'd like to turn some columns into heading
row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345

I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Excel function
to export it Excel.

Other methods may be more complex or need some code to achieve the result.

Hope it helps.

Hennie

"Song Su" wrote in message
...
When export from query to Excel, I'd like to turn some columns into
heading row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345

I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Excel function
to export it Excel.

Other methods may be more complex or need some code to achieve the result.

Hope it helps.

Hennie

"Song Su" wrote in message
...
When export from query to Excel, I'd like to turn some columns into
heading row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345

I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Excel function
to export it Excel.

Other methods may be more complex or need some code to achieve the result.

Hope it helps.

Hennie

"Song Su" wrote in message
...
When export from query to Excel, I'd like to turn some columns into
heading row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345

Hi, Hennie:

I think you mean 'export to excel' which can only export detail band of
report, not header. I'd like to hear your 'other methods'. Or is it possible
to achieve this from Excel side (link to Access query) instead of Access
side?

Thanks

Song

"hennie" wrote in message
...
I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Excel function
to export it Excel.

Other methods may be more complex or need some code to achieve the result.

Hope it helps.

Hennie

"Song Su" wrote in message
...
When export from query to Excel, I'd like to turn some columns into
heading row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345

Hi, Hennie:

I think you mean 'export to excel' which can only export detail band of
report, not header. I'd like to hear your 'other methods'. Or is it possible
to achieve this from Excel side (link to Access query) instead of Access
side?

Thanks

Song

"hennie" wrote in message
...
I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Excel function
to export it Excel.

Other methods may be more complex or need some code to achieve the result.

Hope it helps.

Hennie

"Song Su" wrote in message
...
When export from query to Excel, I'd like to turn some columns into
heading row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345

Hi, Hennie:

I think you mean 'export to excel' which can only export detail band of
report, not header. I'd like to hear your 'other methods'. Or is it possible
to achieve this from Excel side (link to Access query) instead of Access
side?

Thanks

Song

"hennie" wrote in message
...
I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Excel function
to export it Excel.

Other methods may be more complex or need some code to achieve the result.

Hope it helps.

Hennie

"Song Su" wrote in message
...
When export from query to Excel, I'd like to turn some columns into
heading row on top of Excel sheets how to turn this:

LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su

into this?

Class Roster
Instructor: Su
Section: 0545

LastName FirstName SID
Doe John 1234
Doe Jane 2345