Sorry for the confusion. I tried to paste samples but it wouldnt work for me
properly, therefore I will try and explain properly what am after. I have
an existing Access 2003 Database of 576 peoples contact details, however, the
Database contains some people with with only postal addresses, some people
with only email addresses and some people with both. I am trying to create a
queries that will give me results from my 576 people to show just those with
postal addresses, just those with email addresses and possibly results for
those who have both.
I have been in and created a select query with 1st field = firstname, Table
= All Contacts, Sort = Ascending, Show = Ticked, No Criteria. 2nd field =
lastname, Table = All Contacts, Sort = Ascending, No Creiteria, 3rd Field =
Address, Table = All COntacts, Sort = Ascending, Show = Ticked, No Criteria.
and my results show the whole 576 names again and I don't know what to do so
it just shows me those with postal addresses.
Hope that makes sense now.
I anticipate your reply!