help needed with filtering

[sambucaman]

Hi guys
I have a table "customers" with name, address, phone, email etc

I'd like to run a query to list customers by town, but ONLY display results that have email addresses (so I can export this list to my email program)



Using Access2003, I have very limited knowledge of how to do this, is there any way someone can talk me though it? I would normally create a query in design view, and enter
Like "*" &
[List by town] & "*"
to show all my customer in xxxtown.

I've searched and seen i need to enter IS NOT NULL in the email field, but I can get this to work correctly at all. If i enter IS NOT NULL in the criteria row, by search doesn't work and I get a list of ALL towns. If I enter IS NOT NULL in the OR row, my search does work, but I still get results where the email is blank.

Any ideas what I'm doing wrong?

Thanks in advance

[jzwp11]

The query would look something like this. You need an AND, OR will not work since you need both conditions to pull the correct data.

SELECT tblCustomer.txtCustName, tblCustomer.txtAddress, tblCustomer.txtCity, tblCustomer.txtemail
FROM tblCustomer
WHERE tblCustomer.txtemail Is Not Null AND txtCity like "*" &
[List By Town] & "*"