Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: Sumif and transpose with MS Access

    I know excel fairly good but am still somewhat new with MS Access. I have attached a file as an example of my issue. I would like to sum totals for a column according to the month displayed in another column and then transpose that to a horizontal file layout. I can do this with a pivot table in excel but would like to have the ablility to pull the data with SQL to Union with other data before exporting it. Any help would be greatly apppreciated.
    Thanks
    Attached Files Attached Files
    Last edited by mustangman; 02-07-12 at 12:40. Reason: I have resolved my issue using the crosstab query. I guess I should have experimented more before posting. Thanks

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    Look in the Access help file for Crosstab queries.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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