Results 1 to 3 of 3

Thread: Access help.

  1. #1
    Join Date
    May 2002
    Location
    Puyallup, WA USA
    Posts
    3

    Exclamation Unanswered: Access help.

    I am a beginning programmar using Access. I need help defining creating a query that shows the number of items from a particular field as there are many of the same items. As well as create seperate listings for each item as they are also located under different location keys. Can anyone help???????

    This question sounds pretty basic and I feel really dumb for asking.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Look at the following 2 functions: count(*) and group by

    col has values 1,3,6,1,2,1,1,3

    e.g. - select col, count(*) from table group by col

    would return:

    col count(*)
    1 4
    2 1
    3 2
    6 1

  3. #3
    Join Date
    May 2002
    Location
    Puyallup, WA USA
    Posts
    3

    count from 2 columns

    does the same rule apply when you are trying to sort 2 columns by count.

    ex.

    col 1 - High School 1, high school 2 high school 3
    col 2- IIe, IIe, iMac, II, HP HP, IIe, IIe, iMac, II, HP HP
    col 3 - count

    I am trying to create a count list for: high school 1, 2 and 3.

    Jeremy


    Originally posted by rnealejr
    Look at the following 2 functions: count(*) and group by

    col has values 1,3,6,1,2,1,1,3

    e.g. - select col, count(*) from table group by col

    would return:

    col count(*)
    1 4
    2 1
    3 2
    6 1

Posting Permissions

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