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

    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

    Month
    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
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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?
    George
    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
  •