Re: Query Me This -- two references to another tables field

• From: Steve Schapel <schapel@xxxxxxxxxxx>
• Date: Sun, 26 Jun 2005 15:45:25 +1200

Carol,

--
Steve Schapel, Microsoft Access MVP

We would only be interested in how they _initially_ were referred,
regardless of what their first contact with the organization was (so there
would, in fact, only be one possible initial referral source), but we would
want to know what their first contact with the organization was.

I would say that about 50% of the contacts are NOT referred by someone else
(they find the organization on their own), or, they are existing contacts
from a flat-file DB that is being ported to Access, which did not collect
this information (some of which are 6 - 7 years old) -- when the DB is ready
to go, we will attempt to collect this original referral information for as
many of our existing contacts as possible, but you know how people are about
responding to a survey at times, so we may very well not get this
information.  What is your opinion on that percentage of total contacts (400
of about around 800 at this point, and growing quickly) in terms of blanks
if all of this is tracked in the basic contact table?

Also, we want to gather a number of different pieces of information about
the referral, even if self-referred -- 1. Type of first contact with the organization
2. Who referred them, if it is currently a contact in the DB
3. How they found us, if there was no person referring them
4. Date of first contact with organization
5. Notes about the first contact

I actually started out with all this in the tblContact, but removed it and
began working with a separate table at the suggestion of someone in this NG.
Since I am not yet truly adept at append, join, etc., I have erred
consistently on the side of more rather than less tables.

Thanks again for your help,
Carol

.

• Follow-Ups:
  • Re: Query Me This -- two references to another tables field
    • From: CS

• References:
  • Query Me This -- two references to another tables field
    • From: CS
  • Re: Query Me This -- two references to another tables field
    • From: Steve Schapel
  • Re: Query Me This -- two references to another tables field
    • From: CS
  • Re: Query Me This -- two references to another tables field
    • From: Steve Schapel
  • Re: Query Me This -- two references to another tables field
    • From: CS

• Prev by Date: Re: Query Me This -- two references to another tables field
• Next by Date: how do I create a list of mailing addresses, add new addresses, a
• Previous by thread: Re: Query Me This -- two references to another tables field
• Next by thread: Re: Query Me This -- two references to another tables field
• Index(es):
  • Date
  • Thread

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint