Thank you so much for the fast response 🙂

Thanks very much this has worked:

SELECT CAST(MAX(Timesheet_Date) AS Datetime) AS LastTimesheetDate, CAST(MIN(Timesheet_Date) AS dATETIME) AS First_Timesheet_Date, Personnel_Ref,

...

Select Personnel_Ref

From Pers_Static_Personnel_History

where

(SELECT COUNT(Address_Line_1) AS EXP2, Post_Code, Address_Line_1

FROM Pers_Static_Personnel_History

GROUP BY Address_Line_1, Post_Code

HAVING (COUNT(Address_Line_1)...

Thanks again for your help, so I f I then wanted to know the names of the people would this be a sub query?

Thanks so much so it should be like this:

SELECT COUNT(Address_Line_1) AS EXP2, (Post_Code)AS Expr1, Address_Line_1

FROM Pers_Static_Personnel_History

GROUP BY Address_Line_1,...

Thank you so much this works! I now need to sum the charge per purchase order number wish me luck!!!

Thanks John Mitchell-245523

That works perfectly thanks. Now i need to sum the charge by purchase order number! Wish me luck!!!