I see where you're going with that. I had thought about a subselect, but hadn't thought about your approach (don't know why - I should have!). I'll give that a whirl. Thanks.

>Hi Russell,
>
>Try (not tested)
>

>SELECT *
>  FROM mytable mt1
>  WHERE task = lcTask
>    AND NOT EXISTS ( SELECT * FROM mytable
> 		       WHERE ArtID = mt1.ArtID
>			 AND date > mt1.date)
>