Export a grouped report to Excel?

P

Pat Dools

Hello,

I have a report that shows the # of classrooms a given teacher has in
his/her school. In my report, which is based on a query, I have a field
called 'CountOfClassroom' in the Detail section of the report (which I have
hidden). In the Group Footer, I have: Teacher, Sum(Count of classrooms),
Name of School, city, state, zip, etc.

The report is showing the data grouped by teacher as I want it to so I can
get a count of classrooms a given teacher has. However, when I try to export
it to Excel, the only thing that is picked up is what is in the Detail
section of my report ('CountOfClassroom'). Is there any way for Excel to
pick up what I have in the Group Footer of my Access report?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Outlook 2021 export question 0
Section and Page numbering 0
Weekly Report 2
Access 2002 change report header text 0
Export tracked changes to a new document 0
Keeping data together across pages in a report 2

Top