I would like to create a query listing all account types = XXX, but only accounts in states NY, OR and NH?

 How can I do this?

I selected condition, account = XXX AND Address = NY OR address=OR OR address=NH. However, if I do this, nothing shows up.

Why?

Marci change your query:

type = 'xxx' and state in ('NY','OR','NH')

This is simpler and will work. You'll find the condition operator "IN" within Query Builder. You can either browse for the data (use ctrl-click to select) or just type them in (with quotes, but without brackets - as SLX will add those)

Mike