Filtering Report or Union

So I have an email report from a union query.
It has

Firstname,Lastname,Email

Not all records have an email acount.
I would like to filter these out. Doesnt matter if they go via the Union or the report. The report would be more optimal because then I could reverse the effect later to see those who do not have an email. But it really doesnt matter how. Thanks in advance.

Re: Filtering Report or Union

I arrived at calling it union query because that is what some else called it. But pretty much exactly as you thought. I make a query and then select sql in the corner and placed the commands.
I have:

SELECT
contacts.lastname As LastName,
contacts.firstname As FirstName,
contacts.emailaddress As email
FROM contacts
union


SELECT
contacts.lastname As LastName,
contacts.firstname1 As FirstName,
contacts.emailaddress1 As email
FROM contacts


UNION SELECT
children.lastname As LastName,
children.firstname As FirstName,
children.emailaddress As email
FROM children;

Where should, Is Not Null, be placed? I have tried it every where.

Re: Filtering Report or Union

Solved.

I actually found to different methods.
The one I will use is adding a where line to the sql

where emailaddress is not null and emailaddress <> ''

I was trying it with the is not null only and once I figured this out it was smooth sailing, thanks to Norie for pointing to the right road.

The second method is kind of neat
If you right click in the datasheet view in the union query and select
Filter by form it gives you drop down choices to filter by and creates
a new query using that filter. Kind of round-a-bout but it worked just the same.