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