Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Data Access Pages (Access 2003)

    When we run a Pivot Table Report in Access, the total calculation is correct. However, when we save the same report as a Data Access Page, the totals are different. Is this a 'feature' in Access 2033? and if so, has it been fixed in subsequent service realeases? We are still on the original Office 2003.
    Thanks for any help in advance!
    itconc

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Data Access Pages (Access 2003)

    Unfortunately, very few of us work with Data Access Pages, and even fewer try to use Pivot Tables on them. About the only advice I can give is to strongly suggest that you apply the latest Service Packs for Office 2003. There were a number of bugs in the initial release - we chose not to upgrade clients to 2003 until the first Service Pack was released.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Data Access Pages (Access 2003)

    Thanks. I was afraid of that.
    My company is slowly moving to SP1, whereas I have SP2 at home already. Will see what happens under SP1.
    Thanks again!

Posting Permissions

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