Thanks Fabio I will give these a try.

Simon


>Hi Simon,
>
>on VFP you have problem with Datetime split to date,time
>

>SELECT	BFTask.Desc		Task		;
>	,	BFStatus.Desc	Status		;
>	,	BFEvent.Desc	Event		;
>	,	BFWrkGrp.Desc	WorkGroup	;
>	,	BFStaHis.Date	Date		;
>	,	BFStaHis.Time	Time
>	FROM BFHistry	JOIN BFStaHis	ON BFStaHis.PID	=BFHistry.ID		;
>					JOIN BFTask	ON BFTask.ID	=BFHistry.TaskID	;
>					JOIN BFEvent	ON BFEvent.ID	=BFHistry.EventID	;
>					JOIN BFWrkGrp	ON BFWrkGrp.ID	=BFHistry.WorkGrpID	;
>					JOIN BFStatus	ON BFStatus.ID	=BFStaHis.StatusID	;
>	WHERE	ConvertToDateTime(BFStaHis.Date,BFStaHis.Time) = (SELECT MAX(ConvertToDateTime(X.Date,X.Time)) FROM BFStaHis X WHERE X.PID=BFStaHis.PID) ;
>* AND BFStaHis.StatusID<>999999
>

>
>on SQL Server
>

>SELECT	BFTask.Desc		Task		
>	,	BFStatus.Desc	Status		
>	,	BFEvent.Desc	Event		
>	,	BFWrkGrp.Desc	WorkGroup	
>	,	BFStaHis.Date	Date		
>	,	BFStaHis.Time	Time
>	FROM BFHistry	JOIN BFStaHis	ON BFStaHis.ID	=(SELECT TOP 1 ID FROM BFStaHis WHERE PID=BFHistry.ID ORDER BY Date DESC,Time DESC)
>					JOIN BFTask		ON BFTask.ID	=BFHistry.TaskID
>					JOIN BFEvent	ON BFEvent.ID	=BFHistry.EventID
>					JOIN BFWrkGrp	ON BFWrkGrp.ID	=BFHistry.WorkGrpID
>					JOIN BFStatus	ON BFStatus.ID	=BFStaHis.StatusID
>--WHERE BFStaHis.StatusID<>999999
>

>
>Fabio