Hi all,



I'm stumped on how to filter this query the way I want. Hoping someone can help me out.

The query right now has a few conditions in it, but I would also like to only view records that have the same [Employee_Name], [Date], and [Job]

Here is the statement right now.

Code:
SELECT PRM_MASTER__EMPLOYEE.Employee_Name, PRT_CURRENT__TIME.Date, PRT_CURRENT__TIME.Job, PRT_CURRENT__TIME.Extra, PRT_CURRENT__TIME.JC_Cost_Code, PRT_CURRENT__TIME.JC_Category, PRT_CURRENT__TIME.Units, QRates.Unit_Price, Mid([PRT_CURRENT__TIME.Job],11,2) AS TMUP, Mid([PRT_CURRENT__TIME.Job],4,6) AS Site
FROM (PRT_CURRENT__TIME INNER JOIN PRM_MASTER__EMPLOYEE ON PRT_CURRENT__TIME.Employee = PRM_MASTER__EMPLOYEE.Employee) INNER JOIN QRates ON PRT_CURRENT__TIME.JC_Category = QRates.Category
WHERE (((PRT_CURRENT__TIME.Job) Like "*-UP" Or (PRT_CURRENT__TIME.Job) Like "*-TM") AND ((PRT_CURRENT__TIME.WC_Code)="8601"));
Hope that explains it good enough. Let me know if you need me to clear anything up. Thanks!