Creating an Access Query...

J

joe

I have a created a database containing 12 tables. These
tables are called January, February, March etc and contain
the addresses of people who have sent in mail for that
month .

What i would like to do is create a query to search all of
these tables and identify any duplicate addresses, so i
would know if any of the senders have sent in mail in a
preceding month.

Thanks for nay help in this matter.
 
T

tina

-----Original Message-----
I have a created a database containing 12 tables. These
tables are called January, February, March etc and contain
the addresses of people who have sent in mail for that
month .

What i would like to do is create a query to search all of
these tables and identify any duplicate addresses, so i
would know if any of the senders have sent in mail in a
preceding month.

Thanks for nay help in this matter.
.
hi joe.
what you really need to do is normalize your table design.

all your people should be listed in one table, with one
entry for each person (or household, perhaps, depends on
the nature of your data). that will be what is called
a "parent" table. make sure you include a Primary Key
field, such as an AutoNumber field, or another piece of
data that uniquely identifies each record.

then create another table. include one field that is the
same as the primary key field in the parent table. include
another field for the month. this is your "child" table.

now create a one-to-many relationship between the parent
and child tables.

now you can add a record to the child table every time a
person in the parent table sends in mail. this design will
allow you to easily create queries/reports that will show
who is sending what, and when.

if you'd like more detail, you can email me and i'll help
you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top