Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Access Report to Excel (MS Access 2000)

    I have a report that is created in Access that Visible is set to no for the Detail section of the report. I only display group footers that give the totals by sections. The report works fine - but when I try to output to Excel there is no data just the group headings. Is there a way to get the report to output to excel exactly as it appears in Access?
    Thanks shihalud

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Access Report to Excel (MS Access 2000)

    This is a limitation of Access 2000. If you want to export to Excel, place the subtotals in the group header instead of in the group footer.

    See MSKB article ACC2000: How Reports Are Output to Microsoft Excel.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Access Report to Excel (MS Access 2000)

    Thanks for the information. I guess I should just upgrade to a later version of Access. Or if I put the totals in the header so that the totals transfer, will later versions of Access export properly?
    shihalud

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Access Report to Excel (MS Access 2000)

    If you put the totals in the header, any version of Access should export them.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Access Report to Excel (MS Access 2000)

    Thanks Hans works fine - shihalud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •