I have a database of names and email. How do I do a query so it just shows hotmail address and nothing else?

Question

I'm using Microsoft Access

Answer 1

You need to do a query where email address is like @hotmail.com.

I don't have access on hand to give you step by step, but the basic query will look like this:

Select * from mytable where email like '[e-mail]%'

the * means all fields
mytable should be replaced with the name of the table
email should be replaced with the name of your field holding the email address.