Access 2000 report subtotals not exporting to Excel

From: Carolyn (anonymous_at_discussions.microsoft.com)
Date: 06/15/04 

Date: Mon, 14 Jun 2004 19:11:21 -0700

When I use either "Export" or "Analyze with Excel" to
export a report with grouping and subtotals to Excel, the
group footer and it's subtotals does not get included in
the Excel file.

This worked with Access 97 and works on Access 2002 but
does not work on Access 2000. I have searched but cannot
find this problem elsewhere. I have used the same report
on all Access versions, have made it a very simple report,
etc. but it appears that Access 2000 exports with no group
footer row.

Has anyone else seen this? I need a subtotal as per the
report groupings to be automatically generated in the
Excel file which is created by the export.

Thanks and regards
C.

Relevant Pages

  • Issue Exporting a report from Access to Excel
    ... I am currently having an issue exporting a report from access to excel. ... subtotaled fields into the cell I want the subtotals in, ... and drops my formulas into the offset column. ...
    (microsoft.public.access.externaldata)
  • Re: Excel taking too much time to open (13 min)
    ... I suggest you try to find a more appropriate newsgroup that deals with Excel ... I have report in which I am using matrix. ... .So i used three matrix for diffrent subtotals. ...
    (microsoft.public.project)
  • Exporting a Report from Access 2003 to Excel is missing Text field
    ... When I export a Report to Excel all text fields in a group footer are missing ... The report has both text fields and summary fields in the group footer. ...
    (microsoft.public.access.reports)
  • Subtotal problem with Excel 2003
    ... We had an report running a macro setup on Excel 200 and ... 2003 the the subtotals do not appear on the report in the ... I understand that Excel 2003 subtotals ...
    (microsoft.public.excel.programming)
  • Re: subtotals in group footers
    ... I know I can do this using a subreport ... >main report to the point the report is not functional. ... >as many as 35-50 different subtotals in my real report. ... >Need subtotals in the group footer to look like this: ...
    (microsoft.public.access.reports)
Loading