If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Export query to Excel with formated heading
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 |
#3
|
|||
|
|||
Export query to Excel with formated heading
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 |
#4
|
|||
|
|||
Export query to Excel with formated heading
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 |
#5
|
|||
|
|||
Export query to Excel with formated heading
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 |
#6
|
|||
|
|||
Export query to Excel with formated heading
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 |
#7
|
|||
|
|||
Export query to Excel with formated heading
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 |
Thread Tools | |
Display Modes | |
|
|