Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report wizard changes (2000 SP3)

    I created a report using the report wizard in Access 2000.
    When you use the wizard it gives you the option to have a Detail & Summary Report -OR- Summary only report.
    When I created my report I specified a Detail & Summary report.
    Now I need a report with the same layout but as a Summary report only.
    Is there any way to modify this "Detail & Summary -OR- Summary only" option on a report that was created in the report wizard?

    If there is no way to change this in Access do you know if any good utilities (Add Ins) that could do what I need?

    Any help would be appreciated
    Thanks
    John <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    .

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

    Re: Report wizard changes (2000 SP3)

    The main difference between a summary only report and a detail-and-summary report is that the Visible property of the Detail section in a summary-only report is set to No, and in a detail-and-summary report to Yes.

    So make a copy of your detail-and-summary report (Copy then Paste in the database window, or open in design view and select File | Save As...), and set the Visible property of the Detail section to No.

  3. #3
    New Lounger
    Join Date
    Apr 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report wizard changes (2000 SP3)

    Thank you very much
    That was very helpfull
    John

Posting Permissions

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