Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013
    Posts
    3

    Unanswered: Help with a Count...

    Hello,
    I have created a table that is pulling information when entered into a form.
    What I would like to do is to summarize the information into maybe a pivot table or a query..not sure what is best at this point.
    Let me explain my table:
    I have list items that range from P1 to P10 in two seperate columns. How would I do a count so that these two columns get combined together.
    Such as: (Keep in mind, these columns would be laid out next to each other, not bellow)
    Column 1:
    P1
    P2

    Column 2:
    P2
    P3

    I would like the table to take the above information and summarize it as follows:
    Category:
    P1
    P2
    P3
    Number Count:
    1
    2
    1

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Use an UNION query to join the two columns as one column then use a select query to count the P1 to P10 in the Union query.

Posting Permissions

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