lm111

WHERE (ps_design <> "na" AND dateSent>=#01/01/2011#) 

This is correct syntax

lm111

I tried something like this but the output is not right

The only way to solve this is that you try to explain in words which result you want. Show also some records and the result you want