Microsoft Access
--
Questions
--
Followers
Top Experts
Export MS Access Report to Excel but blank footer data
Hello,
I have a simple access report that displays financial data by account number. It has account number, account name and a total. I am grouping and summing by account number. It works great. My client wants to have a version that exports into excel. I thought it would be a simple matter of using the export feature in excel. However, the account number and name, in the summary section do not display in the export to excel. I can export it to text and see the data.
I must be missing something very simple. Or is this a classic “Microsoft slap upside the head” where something that should be simple is not.
The report is very simple. I have attached two screen shots. I added a detail line just for testing. I only want the summary level by account.
Office 2010 for both access and excel.
Thank you,
access.JPG
excel.JPG
I have a simple access report that displays financial data by account number. It has account number, account name and a total. I am grouping and summing by account number. It works great. My client wants to have a version that exports into excel. I thought it would be a simple matter of using the export feature in excel. However, the account number and name, in the summary section do not display in the export to excel. I can export it to text and see the data.
I must be missing something very simple. Or is this a classic “Microsoft slap upside the head” where something that should be simple is not.
The report is very simple. I have attached two screen shots. I added a detail line just for testing. I only want the summary level by account.
Office 2010 for both access and excel.
Thank you,
access.JPG
excel.JPG
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Exporting Access Reports to Excel, ...has never been, nor will it ever be, ...Perfect.
In your report make *sure* that all the controls associated with a field are the exact same size and are all aligned together.
FWIW the report in the attached DB exports to Excel fine for me...
Database102.mdb
In your report make *sure* that all the controls associated with a field are the exact same size and are all aligned together.
FWIW the report in the attached DB exports to Excel fine for me...
Database102.mdb
boag2000,
Thanks for the reply. The problem is the detail section. I only want the summary. I took your sample and deleted the detail section, saved, ran and exported. I get blanks now. It seems that the export only works if there is a detail section.
I also, edited your report and copied the account name and account number fields to the summary level. Saved, ran and exported and the sum shows up but not the account name or number.
Perhaps it is not possible to export a report that only summarizes data
I am thinking I might just do a make table query and export that instead.
Thanks for the reply. The problem is the detail section. I only want the summary. I took your sample and deleted the detail section, saved, ran and exported. I get blanks now. It seems that the export only works if there is a detail section.
I also, edited your report and copied the account name and account number fields to the summary level. Saved, ran and exported and the sum shows up but not the account name or number.
Perhaps it is not possible to export a report that only summarizes data
I am thinking I might just do a make table query and export that instead.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
boag2000,
I like it. I trying to do it all in one report but I think I will make a separate summary query the client can run just for the export. I will give it a shot with the real data.
Thanks.
I like it. I trying to do it all in one report but I think I will make a separate summary query the client can run just for the export. I will give it a shot with the real data.
Thanks.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Boag2000,
I followed your advice. I left the original report the way it is since it is formatted for printing. I made a new query with the grouping in the query. I used that query in a new report stripped of the formatting for export.
Thank you
Epistrophy
I followed your advice. I left the original report the way it is since it is formatted for printing. I made a new query with the grouping in the query. I used that query in a new report stripped of the formatting for export.
Thank you
Epistrophy
Thank you
;-)
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.