Results 1 to 3 of 3
  1. #1
    mikichi is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    45

    question|count table

    hi,
    i have a table with 3 column:



    name proffesion
    daniel police man
    josh teacher
    michael police man

    how i can to create a query that count how much people in each proffesion.
    in my exemple the wuery return:
    police man - 2
    teacher - 1
    thank you,
    miki

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Create a Aggregate Query.
    Add these two fields to a new query.
    Click on the Totals icon (looks like a Sigma) to create an Aggregate Query.
    A new "Totals" row is added in Query Builder view. Under each field, the value will be "Group By".
    Change the Totals row value under the "name" field from "Group By" to "Count".
    View the results.

  3. #3
    mikichi is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    45
    thank you very much!!

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

Similar Threads

  1. Parameter Query/Report Question to Count Text
    By Lettyg82 in forum Reports
    Replies: 6
    Last Post: 08-13-2012, 03:47 PM
  2. Another unique count question
    By atran in forum Reports
    Replies: 2
    Last Post: 05-24-2012, 10:18 AM
  3. Count and crieria on Report question
    By AndycompanyZ in forum Reports
    Replies: 7
    Last Post: 08-10-2011, 06:54 AM
  4. Question; Count function ..
    By efleming in forum Queries
    Replies: 4
    Last Post: 05-27-2011, 08:05 AM
  5. Inventory Count and Receiving Question
    By daniels31790 in forum Access
    Replies: 0
    Last Post: 02-24-2010, 01:33 PM

Posting Permissions

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