Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Puyallup, WA USA

    Unanswered: Help need to figure out count and dups

    I am a beginning programmar using Access. I need help defining and 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 that is under a different location_key. Can anyone help???????

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

    Running Access on Sql Server.

  2. #2
    Join Date
    Feb 2002
    Assuming a table design similar to:


    The query would look something like

    MyField - groupby

    MyID - count

    The groupby and count options are available in the query grid form the total button.

Posting Permissions

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