Results 1 to 2 of 2
  1. 11-15-2011, 10:20 PM #1
    QueryFury
    QueryFury is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    4

    Unique query result issue

    I have a query of 11 employees and their pay for jobs done. Only problem is there are 15 completed jobs with some of the employees doing more than one. When I run my query its only displaying unique name results so I'm only getting 11 results of the 15 jobs instead of all 15.

    How would I change the query to that the results are only unique employee names?
    Reply With Quote Reply With Quote
  2. 11-15-2011, 11:09 PM #2
    pdebaets
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    Please post the query SQL here and let us have a look.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Looping(?) to get Unique Result
    By tonere in forum Programming
    Replies: 3
    Last Post: 11-15-2011, 07:40 AM
  2. VB ADO Query Result Set
    By Bedsingar in forum Access
    Replies: 5
    Last Post: 09-05-2011, 10:45 AM
  3. Evaluate result of sql query
    By Tyork in forum Programming
    Replies: 2
    Last Post: 11-09-2010, 05:41 PM
  4. How do I determine a SQL query result?
    By Trainman in forum Database Design
    Replies: 1
    Last Post: 10-15-2009, 04:49 AM
  5. query that will contain all unique records
    By halcolm1 in forum Queries
    Replies: 0
    Last Post: 01-19-2007, 05:34 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums