Searching specific dates

C

Cunning

Hi,
I'm setting up a contacts database but I need to be able to search the date
in which they were contacted i.e. if they were contacted on 8th September
I'd like to be able to input that somewhere and have their details come up
in a search. How is this done? Please bear in mind I'm a bit of a newbie.

Thanks

Cunning
 
J

John Vinson

Hi,
I'm setting up a contacts database but I need to be able to search the date
in which they were contacted i.e. if they were contacted on 8th September
I'd like to be able to input that somewhere and have their details come up
in a search. How is this done? Please bear in mind I'm a bit of a newbie.

Thanks

Cunning
Click to expand...

What is your meaning of the term "Contact"? I've seen it used in two
senses: a Contact might be a person (e.g. "the person at XYZ Corp.
that you need to get in touch with for purchasing questions") or it
might mean "an encounter", a phone call or email message to a person.

I would guess that you need two tables, one for each sense of the
term: a table of People, with a PersonID, last name, first name, other
information about the person; and a table (which for want of a better
name I'll call Contacts) of interactions with that person. This table
would have the PersonID as a link to the People table, and a
date-contacted field, and any other information about this contact
that you need to record.

You could then create a Query joining the two tables, with a date
criterion on the date-contacted field, to see who was contacted when.

John W. Vinson[MVP]
 
Top