Ok, great.

>Hi Naomi.
>
>I used your tip about using a derived table to get my query working:
>
>Hi Naomi.
>
>Thanks for the tip on using a derived table - I never even thought about it. I finally got this query working:
>
>

>TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 15
>	SELECT * FROM 
>		(SELECT DTOT(VEH.EvtDate) + ((VAL(GETWORDNUM(VEH.EvtTime, 1, ":")) * 3600) + (VAL(GETWORDNUM(VEH.EvtTime, 2, ":")) * 60)) AS start_time, 
>				DTOT(VEH.EvtDate) + ((VAL(GETWORDNUM(VEH.EvtTime, 1, ":")) * 3600) + (VAL(GETWORDNUM(VEH.EvtTime, 2, ":")) * 60) + (VAL(GETWORDNUM(VEH.duration, 1, ':')) * 3600) + (VAL(GETWORDNUM(VEH.duration, 2, ':')) * 60)) AS end_time, 
>				ST.descr AS SvcType_dsc, SVC.servref 
>		FROM funeral!ServiceVehicle VEH WITH (BUFFERING = .T.) 
>			JOIN aserdet SVC WITH (BUFFERING = .T.) ON VEH.service_id = SVC.serviceid 
>			JOIN psvctype ST ON SVC.servtype = ST.code 
>		WHERE VEH.VehCode =  '[[tcVehCode]]' AND VEH.SvcVehID # [[tiSvcVehID]] ) DT 
>	WHERE DT.start_time <= {[[ttEndTime]]} AND DT.end_time >= {[[ttStartTime]]}
>ENDTEXT 
>

>
>Thanks.