Email Address query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm sorry is this is an easy question but I am a beginner at this. Is
there a way to do a query that if someone puts their email address in a
column in a table, it will show up in a query with all of the people that
have put their email addresses in that column? I am doing a volunteer
database and I can't figure it out. Thanks for any help.
 
JP,

I am not 100% sure I understand the question. But if you mean you want
the query to return only those people who have an entry in the email
field, then you can put this in the Criteria of the email field in the
query:
Is Not Null

If this doesn't do the trick, maybe you could post back with an example
of what you've got and what you want.
 
That's what I meant. I am trying to do a query so that if someone types in
their email addres (whatever it is), they will then be added to a query list
so that I can make an emailing list out of it. Sorry it was wasn't clear.
Thanks for the help. :)
 
Back
Top