Results 1 to 3 of 3

Separate Column for Category Total

  1. #1
    Bigd_NC is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2019

    Separate Column for Category Total

    Good morning, I don't know that my thread title makes much sense, but I'll try to explain it below. Assume that I have a table that contains customer information as well as the color of items purchased. I would like my end result to show total types of colors purchased, by customer. Assume the following data, and that the rows are titled: Customer, Color, Amount

    Customer 1 - Black - $25
    Customer 1 - Green - $10
    Customer 2 - Red - $15
    Customer 1 - Red - $15
    Customer 2 - Green - 12

    And so on.

    I am running a query on the above table and I want my end results to be as follows, and the rows titled: Customer, Black, Green, Red and one single line for each customer showing the quantities of purchases by color.

    I'm sure this is a straight forward query but I'm drawing a blank on how to get it to work. Thank you!

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Customer Red Blue Green
    Customer A 10 15 20
    Customer B 15 40 20

    If you're talking about this type of format it's called a crosstab query.

    There's a query wizard that can walk you through easy datasets (like yours is) to set it up.

  3. #3
    Bigd_NC is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2019
    Thank you so much!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-12-2017, 03:09 AM
  2. Replies: 20
    Last Post: 06-16-2017, 01:11 PM
  3. Replies: 3
    Last Post: 04-03-2016, 03:00 PM
  4. Replies: 4
    Last Post: 06-07-2014, 01:54 PM
  5. Replies: 5
    Last Post: 05-10-2014, 09:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums