Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: Query to Find Duplicate Name

    I have a table, employee of the month, that I am trying to query on the mutiple winners. The field name is monthly winners and I would like a query showing only the mutiple winners. Any ideas???

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    SELECT FieldName, Count(*) AS HowMany
    FROM TableName
    GROUP BY FieldName
    HAVING Count(*) > 1
    Paul

Posting Permissions

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