Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access 97 to Excel 2003 (97)

    Check the Top property of the controls in the Detail section of the report - is it the same value for all of them?

    Why don't you export the query to Excel instead of the report, and create the subtotals there?

  2. #2
    Star Lounger Roderick's Avatar
    Join Date
    Jan 2004
    Location
    Near Halifax, Nova Scotia, Canada
    Posts
    88
    Thanks
    5
    Thanked 4 Times in 4 Posts

    Re: Access 97 to Excel 2003 (97)

    Thanks for the solution, Hans - seems that the Top property on the two columns that were out of order were just slightly different from the others. Once I fixed those so all columns had the same top position, the report exports now in the correct order.

    As for exporting the query (hadn't thought about that) it's simpler to export the report. To get at the query I have to open a separate report writer program and then would have to insert group totals whereas the report is generated from within the accounting program and already has the group totals.

    Rod

  3. #3
    Star Lounger Roderick's Avatar
    Join Date
    Jan 2004
    Location
    Near Halifax, Nova Scotia, Canada
    Posts
    88
    Thanks
    5
    Thanked 4 Times in 4 Posts

    Access 97 to Excel 2003 (97)

    Not sure if this is an Access or Excel issue but since it starts with Access, I'll post it here.

    I use an accounting program that is built using MS Access 97 as the database. We haven't upgraded it to to be compatible with later version of Access (long story - don't ask why!)

    One of the reports that I created and use regularly needs to be exported to an Excel 2003 spreadsheet for some additional "tweaking" and when I export the report, I get some of the columns coming up in the wrong order. Wondering if anyone knows why this is happening? I've put some screen shots in a PDF file you can see here: [Link deleted - no longer required]

    Note that columns B & C in the spreadsheet are in the wrong location. It's simple to cut & paste them into the right locations but wondering why this happens in the first place? One would think that Microsoft office applications would be compatible with each other.

Posting Permissions

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