Lutz,

Thanks so much for replying, but I can't provide table def. and sample data. Corporate rules ;(

Tested it, and no go =(

Is it possible to if/then in side of a where?

if status like __ and date submitted between x and z then true else skip? >.>

Think I got it..

WHERE

((Right(TO],(Len([TO])-4))) Like '%5%') AND

dbo.AT.DateClosed Is Null AND

([meeting date] =

(Select MAX([meeting date]) from [Comments]

WHERE AT.[Id] = Comments.[ID]) OR

[meeting date] is null)AND NOT

((AT.Status LIKE '%Submitted%' AND...