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

    Unanswered: Export format into Excel

    I have a formating questions

    I have the following fields

    Division, Cost Centre, Month, Maintenance Cost, Insurance Cost, Accident cost

    is there a way to export this into excel so that the rows have

    Division-Cost centre
    Maintenance Cost
    Insurance Cost
    Accident cost

    and column has the Month

    Cross tab isnt applicable as i have more than the three fields of Maintenance, Isurance and Accidents. Please refer to attachment the sheet titled 'Current format' is how i am outputting from a query and i need it in the format as per sheet 'desired format'
    Attached Files Attached Files
    Last edited by Databaseman; 08-30-07 at 03:56.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    The code bank has some lovely stuff on Excel exports and fiddles by our very own pootle flump - so don't you forget about that invaluable resource!

    With regards to your problem: Why can't you use a cross-tab? I'm assuming you have a pre-defined number of columns - so what's the problem?
    Home | Blog

Posting Permissions

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