Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Crosstab Report shows last line totals repeated (Access 2003 SP2)

    I have a report that is based upon a crosstab query. The report was based upon a Employee Sales report from the solutions database.

    The report shows the first 3 columns (desc A, Desc B and desc C) correctly. However all the crosstab totals across the page are repeated from the last line of the report.

    I cannot work out just why this is happening.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Crosstab Report shows last line totals repeated (Access 2003 SP2)

    Don't worry about this, I have solved my own problem.

    I had copied code from the other application (Employee Sales) and had not noticed that the ReportHeader Section was labelled incorrectly (label was ReportHeader3 instead of ReportHeader) and therefore was not being executed.

Posting Permissions

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