Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015

    Unanswered: access report export

    I've a access report with page size A3 14 fields and last 6 columns are date columns. When i see the report view then it looks right order. When i try to export the report into excel it returns date columns first and followed by other columns. I use the below code to export report to excel.

    DoCmd.OutputTo acOutputReport, "myreport", acFormatXLS, "c:\test.xls", False

    I am not able to figure out the errors. Can someone help me please if you can spot any errors.

    Many Thanks

  2. #2
    Join Date
    Mar 2015
    Without being able to see an example of your query that the report is based on, and the design of the report, my first guess is that perhaps your query does not return the data in the same order that you have the fields laid out in the report. Off the top of my head, I am not sure just how Access processes a report to do an export of it to Excel so this may be totally wrong but without more information, I would try looking at that as a potential answer.

    You might also find the answer your are looking for in this article.

Posting Permissions

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