Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    37

    Unanswered: include one occurrence in list

    Hi can anyone help with this one ?

    I have a query result, which shows all employee’s that are team leaders on projects.

    I want to have a combo box with forename and surname off each employee that is a team leader which then shows a subform of the project descriptions .

    Problem is all occurrences of the employee's name in the field are in the list so say joe bloggs is a leader on 8 projects then his name is in the list 8 times!

    This is the current sql
    Code:
    SELECT EMPLOYEE.EmpID, EMPLOYEE.EmpForename, EMPLOYEE.EmpSurname
    FROM EMPLOYEE INNER JOIN PROJECT ON (EMPLOYEE.EmpID = PROJECT.EmpID) AND (EMPLOYEE.EmpID = PROJECT.EmpID);
    Any ideas/suggestions

    JD
    Last edited by JD|; 01-03-04 at 16:12.

  2. #2
    Join Date
    Dec 2003
    Posts
    172
    JD

    right-click on the query designer in Access, open up the query properties. set the query to unique records. see if that works.

    You can use the UniqueRecords property to specify whether to return only unique records based on all fields in the underlying data source, not just those fields present in the query itself.

    You can use the UniqueValues property when you want to omit records that contain duplicate data in the fields displayed in Datasheet view. For example, if a query's output includes more than one field, the combination of values from all fields must be unique for a given record to be included in the results.

    (from Microsoft Help)

    JoeG

  3. #3
    Join Date
    Dec 2003
    Posts
    37
    Thanks so much Joe, Thats another problem sorted


    JD

Posting Permissions

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