Show One record in Access Query

[Eranka]

Hi Everyone

I have a query which includes EmpID,EmpName,DeptID,Deptname

When i search the query by EMPID it should show only the department that he is working.

But with my current query when i search the datasheet view shows multiple data's. (duplicates)

how to limit it to show just one data.

[June7]

Post query SQL statement.

Post example of raw data.

[SierraJuliet]

Like June7 said you need to post samples but in the meantime.

SELECT EmpID, EmpName, DeptID, Deptname
FROM (SELECT DISTINCT EmpID FROM TableName)
WHERE Condition = Criteria;