TRYING TO MAKE QUERIES/TABLES FROM MY MASTER DATABASE

  • Thread starter Thread starter C
  • Start date Start date
C

C

I have a Master Database with 576 records. Some records have only postal
addresses and some records only have email addresses. What is the easiest
way to produce a list of both from the Master Database?
 
I'm not sure what you mean by Master Database. If you are trying to say
that you want a list of only those records which contain both email and
address fields then filter the fields with

Is Not Null

Evi
 
I have a Master Database with 576 records. Some records have only postal
addresses and some records only have email addresses. What is the easiest
way to produce a list of both from the Master Database?
Click to expand...

What do you mean by "a list of both"? Could you post two or three records of
sample data and show the desired result?
 
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!
 
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.
Click to expand...

The easiest way to share a query on the newsgroups is to open it in SQL view;
use the View menu option and choose SQL, or click the dropdown on the leftmost
tool in the query design toolbar and choose SQL.

To display only those records with data in the postal address field put a
criterion on that field of

IS NOT NULL

You can do the same with the EMail field. If the two criteria are on the same
line you will see those records where *both* the fields have data.
Alternatively, you can put the two criteria on separate lines; this will use
OR logic and show all records where one or the other exists. To see all
records with a mail addess but no email, use IS NOT NULL on the address
criterion, and IS NULL on the email (on the same line of the grid).
 
John my friend you are the man! I tried all sorts by frigging with criterion
etc.. and nothing was working! High five to you John W Vinson! Thanks Heaps!
 
Back
Top