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

    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.
    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
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Look in the Access help file for Crosstab queries.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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