Want to see only those clients who has email id

[sougata]

I have a table -'client' with 5 fields,
id
name
address
email
mobile no

I want to see only those clients who has email id.

I know its simple but not so simple to a layman like me

Please help

 

[EMP]

In a query, put Is Not Null in the criteria for the ID field.

^

 

[sougata]

Thanks for your help,but
How could I do it by using form?
Actually I want to use a check box in a form.

 

[EMP]

You can put the criteria in a new column in the query grid like this, using the correct form name and check box name:-
------------------------------------------------
Field: IIf([Forms]![formName]![checkBoxName]=True, [ID] Is Not Null, True)

Show: uncheck

Criteria: True
------------------------------------------------

which is derived from Jon K's basic criteria format in his thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312


Now when the check box on the form is checked and the query is run, the [ID] Is Not Null in the IIF expression will return all the records where the ID field is not empty. When the check box on the form is not checked, the final True in the IIF expression will return every ID including the empty IDs.

^